[
https://issues.apache.org/jira/browse/CALCITE-1305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1305:
---------------------------------
Description:
When running in case-insensitive mode, GROUP BY wrongly thinks table aliases of
different case are different. For example,
{code}
SELECT deptno
FROM Emp
GROUP BY emp.deptno
{code}
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.
was:When running in case-insensitive mode, GROUP BY wrongly thinks table
aliases of different case are different.
> Case-insensitive table aliases and GROUP BY
> -------------------------------------------
>
> Key: CALCITE-1305
> URL: https://issues.apache.org/jira/browse/CALCITE-1305
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: 1.9.0
>
>
> When running in case-insensitive mode, GROUP BY wrongly thinks table aliases
> of different case are different. For example,
> {code}
> SELECT deptno
> FROM Emp
> GROUP BY emp.deptno
> {code}
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
