Hello.
Yes, it looks like a bug. IN predicate may have a row value expressions in
its right side, but this case is not currently supported. Older version
works only because it incorrectly parses them as arrays.
Use can use something like
SELECT col1 FROM x WHERE (col1, col2) IN (VALUES ('a1', 'b1'),('a2', 'b2'));
as a workaround.
Please not that NULL is neither equal nor not equal to NULL, you can't
fetch ('a3', null) in that way (and with your original query too in
databases that support it correctly).
--
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/b2efda4d-64a4-4269-8c09-5ea1fad4cd64%40googlegroups.com.
