If a table contains null value on some records (even if the data is not
matched by the filter),
h2 generate exeption with version 1.4.200 (with versione 1.4.197 it's
work):
SQL [22018] [22018]: Data conversion error converting "ROW (a3, null)";
Test case:
CREATE TABLE x (
col1 varchar(10),
col2 varchar(10)
)
INSERT INTO x (col1, col2) VALUES ('a1', 'b1')
INSERT INTO x (col1, col2) VALUES ('a2', 'b2')
INSERT INTO x (col1, col2) VALUES ('a3', null)
SELECT col1 FROM x
WHERE
(col1, col2) IN (('a1', 'b1'),('a2', 'b2'))
--
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/f8471004-a857-4a53-9d82-a2f48366b5ff%40googlegroups.com.
