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.
