AND ( 1 = 2 ) always false -> empty result
Does UNION / UNION ALL behave differently with empty results? P [email protected] 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/9a560701-4322-42cd-9108-4fa20848395cn%40googlegroups.com.
