Re: [h2] Query in latest version is returning empty results
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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/9db72178-922f-431d-8442-ba995514d62cn%40googlegroups.com.
Re: [h2] Query in latest version is returning empty results
On Fri, 2022-02-11 at 11:57 -0800, Ajay Bhide wrote: > Hi , > > The exact same query which returns the expected result-set in the > version 1.4.187, is returning empty result set with both the versions > 2.0.206 and 2.1.210. Can someone be able to help on this? Based on your example, you may better ask the Perl obfuscation contest for help. Best regards Andreas -- 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/daa58fd064780d91ad1dcdece15d37b23bf918ef.camel%40manticore-projects.com.