sqlite> create table t(a integer primary key); sqlite> insert into t values (1), (3), (5); sqlite> select count(*) from t where a>0; 3 sqlite> select count(*) from t where (a,1)>(0,0); 0
Surely it should be 3 in both cases????? If t is created as ‘create table t(a)’ both return 3. Tried it in 3.21 and 3.22. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
