Hi, I think this is due to issue 387: WHERE condition getting pushed into sub-query with LIMIT. I'm afraid you will not be able to use such subqueries any longer, and have to find a different way to solve this problem. I'm sorry.
With "simple test case" I actually meant a "a short, self contained, correct (compilable), example of the problem". See http://sscce.org/ - A simple Java program that created the needed tables and data, and then runs the query. It should contain only those tables, columns, and data that are not need to reproduce the problem, making the test case as simple as possible. Regards, Thomas On Sat, Jun 2, 2012 at 12:18 AM, Dani <[email protected]> wrote: > Hi, > > OK, I uploaded 3 files that hopefully will help to circle in on this! > They all have 3 tables with the same structure. > Table QUERIES contains 2 queries --> copy/paste, they should run fine. > > username xy > no password > > > This one gets the results the way I would like them to be (and they > have been with previous versions): > > 1.3.165_A -- > http://www.file-upload.net/download-4408331/test_A_1.3.165.h2.db.html > > > This one is exactly the same only with less data and the INNER JOIN > delivers only 1 match which it should NOT: > > 1.3.165_B > http://www.file-upload.net/download-4408294/test_B_1.3.165.h2.db.html > > > And finally this one is of the next H2 version and should be opened > accordingly. > It delivers totally different results but is the same as 1.3.165_B: > > 1.3.166_B > http://www.file-upload.net/download-4408298/test_B_1.3.166.h2.db.html > > > > I tested with the according org.h2.Drivers 1.3.165 and 1.3.166 with > EQ. > I hope this is what you call a test case ;-) > > Thanks a lot, > > > Dani > > -- > 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. > -- 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.
