[DERBY-6909] Invalid grouping by multiple columns when use function (Apache Derby 10.10.2.0)

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.10.2.0, 10.13.1.1
• Component/s: SQL
• Labels: queries
• Urgency: Low
• Bug behavior facts: Wrong query result
• Assignee: Indumini Ayomi
• Reporter: Boris Brinza
• Created: 26/Aug/16 13:29
• Updated: 20/Aug/17 16:32

Description

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)