Hello H2 community, I have identified the following bug in version 1.3.158. Using an ALL clause against a subquery appears FALSE if the subquery is empty, whereas it should appear TRUE (like it does in Oracle). For example, the SQL below should return one row from the SELECT, but it returns no rows.
create table test1( testcol1 int ); create table test2( testcol2 int ); insert into test1( testcol1 ) values( 1 ); select * from test1 where testcol1 >=all ( select testcol2 from test2 ); Can this be fixed please? Thank you, David. -- 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.
