According to my understanding of the SQL standard, the following query should work, but doesn't on SQLite 3.25.2:
SELECT 1 WHERE (1, 1) IN ((1, 1), (1, 2)); The error I'm getting (via xerial) is: SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (row value misused) A workaround is this: SELECT 1 WHERE (1, 1) IN (SELECT 1, 1 UNION ALL SELECT 1, 2); Thanks, Lukas _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users