[jira] [Updated] (CALCITE-1305) Case-insensitive table aliases and GROUP BY

["Julian Hyde (JIRA)" <ji...@apache.org>]

     [ 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)