[ https://issues.apache.org/jira/browse/DERBY-6909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-6909: ----------------------------------- Attachment: derby.log Attached 'derby.log' contains the 4 different SELECT queries, run with derby.language.logQueryPlan=true. > Invalid grouping by multiple columns when use function (Apache Derby > 10.10.2.0) > ------------------------------------------------------------------------------- > > Key: DERBY-6909 > URL: https://issues.apache.org/jira/browse/DERBY-6909 > Project: Derby > Issue Type: Bug > Components: SQL > Reporter: Boris Brinza > Priority: Minor > Labels: queries > Attachments: derby.log > > > Create table TEST: > create table TEST (name varchar(10), label varchar(10)); > insert into TEST values ('johnny', 'label_1'); > insert into TEST values ('johnny', 'label_2'); > These queries returns 2 rows 'JOHNNY': > select upper(name) from TEST group by name, label > select upper(name) from TEST group by upper(name), label > When grouping is changed this way, query returns only 1 row 'JOHNNY': > select upper(name) from TEST group by upper(name), upper(label) -- This message was sent by Atlassian JIRA (v6.3.4#6332)