In 3.6.22, CREATE TABLE i1 AS SELECT 0 AS value;
CREATE TABLE i2(value integer); INSERT INTO i2 VALUES(0); CREATE TABLE s AS SELECT '0' AS value; SELECT typeof (value) FROM i1; select (select value from i1) = (select value from s); SELECT typeof (value) FROM i2; select (select value from i2) = (select value from s); I would expect the 2 select statement yield the same value, but one shows 0, the other 1. Is this a bug? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
