[ https://issues.apache.org/jira/browse/ASTERIXDB-2760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Lychagin resolved ASTERIXDB-2760. ---------------------------------------- Resolution: Fixed > Group by expression substitution must be case insensitive for builtin > function names > ------------------------------------------------------------------------------------ > > Key: ASTERIXDB-2760 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-2760 > Project: Apache AsterixDB > Issue Type: Bug > Components: COMP - Compiler > Affects Versions: 0.9.4 > Reporter: Dmitry Lychagin > Assignee: Dmitry Lychagin > Priority: Major > Fix For: 0.9.6 > > > When a grouping expression is used in the SELECT clause the compiler replaces > the expression in the SELECT clause with a variable assigned to that > expression by the GROUP BY clause. > {noformat} > SELECT f(x) FROM ds GROUP BY f(x) AS y > {noformat} > is rewritten by the compiler into > {noformat} > SELECT y FROM ds GROUP BY f(x) AS y > {noformat} > However when comparing GROUP BY / SELECT expressions the compiler currently > compares function names in a case-sensitive fashion (function names are not > yet normalized at that point). This is incorrect for built-in functions > because their names are supposed to be case insensitive. -- This message was sent by Atlassian Jira (v8.3.4#803005)