In order to diagnose such an issue you need to strip the query down to a reasonable small sized example. To get an idea what you can do: 1) decopose the union parts of the query and check for differences 2) analyze the AND claues in the where condition to see which part possibly causes the differnce Developers need a very comprehensive standalone testcase in order to further diagnose a possible issue.
Reards, Christian -- 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/9db72178-922f-431d-8442-ba995514d62cn%40googlegroups.com.
