Boris Brinza created DERBY-6909:
-----------------------------------

             Summary: 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


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)

Reply via email to