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)