I am executing a query that is failing to join on the primary key. If I query by other values the record is present in the table with a matching index, but if I attempt to query by the index value no records are returned.
I poked around on it trying to get it to reconstruct the index but I could not figure out how to drop the index because it isn't possible to drop it as it is referenced in constraints. I attempted a dummy update of the record, again to try and force a reconstruction, but it gave a "Timeout trying to lock table" error though the database was opened in embedded mode in SQuirreL with no pending transactions. We are using the latest stable version of H2DB. The database is not large, and it is easy to illustrate the problem with 3-4 queries, so if Thomas sees that and would like to see it, there is no problem supplying a test case. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1aeb903b-f778-4771-a269-375c08c1a93d%40googlegroups.com.
