Error in comparison test when using "group by"

[GoogleCodeExporter]

Hi,

I am using the version H2 1.3.175.
Here are the requests to reproduce the issue:

CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
insert into test values (1, 'test1');
insert into test values (2, 'test2');

select * from test;

Output:
ID      NAME  
1   test1
2   test2

select id,
name IN ('test2','test3') col
from test;

Output:
ID      COL  
1   FALSE
2   TRUE

select id,
name IN ('test2','test3') col
from test
group by id;

Expected output:
ID      COL  
1   FALSE
2   TRUE

Seen output:
ID      COL  
1   TRUE
2   TRUE

Thanks and regards.

Original issue reported on code.google.com by cheve.cy...@gmail.com on 23 Jan 2015 at 11:03

[GoogleCodeExporter]

Hi,

I finally had time to look at it and fixed the problem (in the trunk).

Regards,
Thomas

Original comment by thomas.t...@gmail.com on 12 Mar 2015 at 6:51

• Changed state: Accepted