[PHOENIX-3958] COALESCE in GROUP BY statement where the result is an empty string fails

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 4.7.0
• Fix Version/s: 4.11.0

Environment

Windows Server 2012;
Phoenix Driver: phoenix-4.7.0.2.5.0.0-1245-client.jar

• Assignee: Unassigned
• Reporter: Tiago Correia
• Created: 19/Jun/17 13:56
• Updated: 19/Jun/17 15:24
• Resolved: 19/Jun/17 15:24

Description

If you have, for example, the statement below:

SELECT COALESCE(ColumnA, '')
FROM TableA
GROUP BY COALESCE(ColumnA, '');

I get the error

(ERROR 1018 (42Y27): Aggregate may not contain columns not in GROUP BY. null

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