Thank you Evgenij, Life saver. On Tuesday, August 6, 2019 at 6:43:24 PM UTC+5:30, Evgenij Ryazanov wrote: > > Hello. > > IN predicate with empty list is not valid according to the SQL Standard. > However, some databases, including H2, support it. > > H2 1.4.193 and later versions don't allow it in DB2, MySQL, Oracle, and > PostgreSQL compatibility modes because these databases don't allow it. > > When you use a compatibility mode you shouldn't rely on the H2-specific > features. >
-- 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/59b7dca4-de1c-4061-8757-33f7f49dde8f%40googlegroups.com.
