[
https://issues.apache.org/jira/browse/PHOENIX-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14556540#comment-14556540
]
Sergio Lob commented on PHOENIX-2004:
-------------------------------------
To reproduce:
CREATE TABLE SERGIO (I INTEGER PRIMARY KEY) ;
UPSERT INTO SERGIO VALUES (5) ;
UPSERT INTO SERGIO VALUES (6) ;
SELECT
I, (CASE WHEN TRUE THEN 10 ELSE -10 END),
MAX((CASE WHEN TRUE THEN 10 ELSE -10 END))
FROM SERGIO
GROUP BY I;
Wrong answer returned for select list item 3. This was reproduced using java
JDBC (JDBC driver V4.3).
> 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)
