With the latest version I have the same problem. Am I understanding right that "Select-Statement" and "Select-Statement" from EXPLAIN must be the same?
----- Pseudo-Code of my "Test-Statament": SELECT * FROM (1,2,5) WHERE C1 > SOME (2,5) Result: 5 Pseudo-code of "Test-Statement" after EXPLAIN: SELECT * FROM (1,2,5) WHERE C1 IN (2,5) Result: 2,5 On Thursday, 9 January 2014 11:34:03 UTC+1, Thomas Mueller wrote: > > Hi, > > Sorry I can't reproduce the problem with the latest version (1.3.174). > Maybe it is already fixed? > > Regards, > Thomas > > > > On Wed, Jan 8, 2014 at 11:50 PM, <[email protected] <javascript:>> wrote: > >> Test-statement: >> >> //Library: h2-1.3.170.jar >> >> --EXPLAIN >> SELECT * FROM ( >> --Test dataset >> SELECT * FROM VALUES(1) >> UNION ALL >> SELECT * FROM VALUES(2) >> UNION ALL >> SELECT * FROM VALUES(5) >> ----------------------- >> ) WHERE C1 > SOME ( >> SELECT C1 FROM ( >> --Test dataset >> SELECT C1 FROM VALUES(1) >> UNION ALL >> SELECT C1 FROM VALUES(2) >> UNION ALL >> SELECT C1 FROM VALUES(5) >> ----------------------- >> ) WHERE C1 > 1 >> ) >> >> Resultset: C1(5). That's right, C(1,2,5) > C(2,5). >> Resultset of statement after explain: C1(2,5). This correspond to >> C(1,2,5) >= C(2,5). >> >> -- >> 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 [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
