[jira] [Commented] (HIVE-12277) Hive macro results on macro_duplicate.q different after adding ORDER BY

["Lefty Leverenz (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-12277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15225531#comment-15225531 ] 

Lefty Leverenz commented on HIVE-12277:
---------------------------------------

Doc note:  This has been documented in the wiki on the note about version information for macros:

* [Language Manual DDL - Create/Drop Macro | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create/DropMacro]

> Hive macro results on macro_duplicate.q different after adding ORDER BY
> -----------------------------------------------------------------------
>
>                 Key: HIVE-12277
>                 URL: https://issues.apache.org/jira/browse/HIVE-12277
>             Project: Hive
>          Issue Type: Bug
>          Components: Macros
>    Affects Versions: 1.2.0
>            Reporter: Jason Dere
>            Assignee: Pengcheng Xiong
>             Fix For: 1.3.0, 2.0.0
>
>         Attachments: HIVE-12277.01.patch
>
>
> Added an order-by to the query in macro_duplicate.q:
> {noformat}
> -select math_square(a), math_square(b),factorial(a), factorial(b), math_add(a), math_add(b),int(c) from macro_testing;
> \ No newline at end of file
> +select math_square(a), math_square(b),factorial(a), factorial(b), math_add(a), math_add(b),int(c) from macro_testing order by int(c);
> {noformat}
> And the results from math_add() changed unexpectedly:
> {noformat}
> -1      4       1       2       2       4       3
> -16     25      24      120     8       10      6
> +1      4       1       2       1       4       3
> +16     25      24      120     16      25      6
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)