[jira] [Created] (PHOENIX-2004) Wrong answer: SELECT MAX((CASE WHEN TRUE THEN 10 ELSE -10 END))

[Sergio Lob (JIRA)]

Sergio Lob created PHOENIX-2004:
-----------------------------------

             Summary: Wrong answer:  SELECT MAX((CASE WHEN TRUE THEN 10 ELSE 
-10 END))
                 Key: PHOENIX-2004
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2004
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.3.0
         Environment: Linux lnxx64r6 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 
10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
            Reporter: Sergio Lob


SELECT MAX((CASE WHEN TRUE THEN 10 ELSE -10 END)) returns incorrect value 
(returns 1 instead of 10). Original request is:

SELECT I, (CASE WHEN TRUE THEN 10 ELSE -10 END),
MAX((CASE WHEN TRUE THEN 10 ELSE -10 END))
FROM SERGIO GROUP BY I;





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