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)