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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/59b7dca4-de1c-4061-8757-33f7f49dde8f%40googlegroups.com.
