AND ( 1 = 2 ) always false -> empty result
Does UNION / UNION ALL behave differently with empty results? P cbvm...@googlemail.com a következőt írta (2022. február 12., szombat, 10:09:25 UTC+1): > 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/9a560701-4322-42cd-9108-4fa20848395cn%40googlegroups.com.
