Hi, I was using a query of the form SELECT ... NOT IN (SELECT ...) in version 1.3.174. The same query produces different results when running on 1.4.190.
Steps to reproduce: 1. Create a DB using H2 1.3.174: drop table t1; create table t1 (C1 integer); insert into t1 (C1) values (1); insert into t1 (C1) values (2); insert into t1 (C1) values (3); insert into t1 (C1) values (4); 2. Run the following query: select * from t1 where c1 not in (select c1 from t1 order by c1 desc limit 2); Returns: C1 1 2 3. When opening the DB with H2 1.4.190 the same query returns an empty result set. Also when the DB is created with 1.4.190 the query returns an empty result set. Does somebody know a workaround? Regards, Alex -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
