SQLite Forum

sql parser error
Login
Chronological Hierarchical 
when I exec this sql:
"SELECT *  FROM tt WHERE (a, b) IN ( (1, 2), (3, 4) );",I received the error message:"row value misused".


The table tt 's DDL is:

CREATE TABLE IF NOT EXISTS tt (  a, b );

then the tt 's DML is:

INSERT INTO tt VALUES (  1, 2 );
INSERT INTO tt VALUES (  3,4 );

INSERT INTO tt VALUES (  5, 6 );


and then exec the sql"SELECT *  FROM tt WHERE (a, b) IN ( (1, 2), (3, 4) );",and an error returned!