[CALCITE-1305] Case-insensitive table aliases and GROUP BY

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 05/Jul/16 19:57
• Updated: 27/Feb/24 22:23
• Resolved: 06/Jul/16 05:34

Description

When running in case-insensitive mode, GROUP BY wrongly thinks table aliases of different case are different. For example,

SELECT deptno
FROM Emp
GROUP BY emp.deptno

throws Expression 'deptno' is not being grouped but this is wrong; it is a valid query, because Emp and emp are equivalent in a case-insensitive context.

Issue Links

• relates to: CALCITE-319 Table aliases should follow case-sensitivity policy