We've encountered strange sqlite behavior: SQLite version 3.7.15.2 2013-01-09 11:53:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(v int4); sqlite> insert into t values (1),(2),(3); sqlite> select * from t where v = (select v from t); 1 sqlite> select * from t where v in (select v from t); v ---------- 1 2 3
While on postgres it works like this (as far as I remember oracle does this as well, and that's the way it should work imho):
mail=> create table t (v int4); CREATE TABLE mail=> insert into t values (1),(2),(3); INSERT 0 3 mail=> select * from t where v = (select v from t); ERROR: more than one row returned by a subquery used as an expression mail=> select * from t where v in (select v from t); v --- 1 2 3 (3 rows) Is this a bug, or a feature? Marcin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users