I don't know guys. It looks like a bug to me. The problem is twofold: (1) Whenever I see a "duplicate" record, the database is actually skipping a record. In other words, when I see 218 at the end of the first query and 218 at the start of the second, record 217 is missing. That is bad. (2) The query response is inconsistent. I see 4 different responses coming back from the same query on a static table. I don't think that's right. I'll update my queries to try to circumvent the issue(s) for now but I think this issue should be documented and fixed at some point. Respectfully,Peter
-- 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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/1917263963.8514381.1713255567640%40mail.yahoo.com.
