[sqlite] Row value in predicate doesn't work

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

Re: [sqlite] Row value in predicate doesn't work

Following up, this also doesn't seem to be implemented: SELECT 1 WHERE (1, 1) IS NULL; I think this should be added for completeness' sake of the row value predicate functionality On Wed, Oct 10, 2018 at 3:42 PM Lukas Eder wrote: > According to my understanding of the SQL stand