Jason Dere created HIVE-12277:
---------------------------------

             Summary: 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
            Reporter: Jason Dere


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)

Reply via email to