Thank you Thomas. I am now using 1.3.160, and I can confirm that my problem is fixed.
Very much appreciated. Cheers, David. On Sep 10, 9:16 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > Thanks a lot! There are a number of similar cases where the current > behavior is incorrect. I will fix those and add test cases. The > following cases are now fixed in the trunk: > > drop table test; > create table test(id int); > insert into test values(1); > select * from test where id >= all(select id from test where 1=0); > select * from test where id = all(select id from test where 1=0); > select * from test where id = all(select id from test union all select > id from test); > select * from test where null >= all(select id from test where 1=0); > select * from test where null = all(select id from test where 1=0); > select * from test where null = all(select id from test union all > select id from test); > select * from test where id >= all(select cast(null as int) from test); > select * from test where id = all(select null from test union all > select id from test); > select * from test where null >= all(select cast(null as int) from test); > select * from test where null = all(select null from test union all > select id from test); > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
