phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tiago Correia (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3958) COALESCE in GROUP BY statement where the result is an empty string fails
Date Mon, 19 Jun 2017 13:57:00 GMT
Tiago Correia created PHOENIX-3958:
--------------------------------------

             Summary: COALESCE in GROUP BY statement where the result is an empty string fails
                 Key: PHOENIX-3958
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3958
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
         Environment: Windows Server 2012;
Phoenix Driver: phoenix-4.7.0.2.5.0.0-1245-client.jar
            Reporter: Tiago Correia
            Priority: Minor


If you have, for example, the statement below:

{code:sql}
SELECT COALESCE(ColumnA, '')
FROM TableA
GROUP BY COALESCE(ColumnA, '');
{code}

I get the error
{noformat}
(ERROR 1018 (42Y27): Aggregate may not contain columns not in GROUP BY. null
{noformat}

If I use a space {{' '}} instead of an empty string {{''}}, it starts working.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message