You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/23 23:11:39 UTC
[jira] [Updated] (PHOENIX-2004) Wrong answer: SELECT MAX((CASE
WHEN TRUE THEN 10 ELSE -10 END))
[ https://issues.apache.org/jira/browse/PHOENIX-2004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-2004:
----------------------------------
Fix Version/s: 4.8.0
> 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
> Fix For: 4.8.0
>
>
> 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)