Hello Thomas, We have a database that works fine using the 1.0.72 version of H2. We recently tried to use it with the builds 1.1.106 and 1.1.107. The database opens fine,but when running some queries it returns no results. For example adding an "ORDER BY" clause causes a query to return no results. When we go back to the previous H2 version on the same database it works fine. When we deleted the index file and recreated it using the new H2 it also works fine.
So it seems that there is something in the index file that causes the new H2 to fail, but works fine on the older build. I could send you the entire database (it's small - about 2.5 MB) and the queries that give us weird results. This way you can try it for yourself using the old and the new H2 builds. Alex --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
