2010/4/28 Dan Bishop <danbisho...@gmail.com>: ... > Why the inconsistency?
There are a lot of same problems. See http://www.mail-archive.com/sqlite-users@sqlite.org/msg47832.html sqlite> select 1='1'; 0 sqlite> create table test(a text); sqlite> insert into test values (1); sqlite> select * from test where a='1'; 1 sqlite> select * from test where a=1; 1 So 1 can be equal to '1' and can be not. My tests and dummy patch for tclsqlite http://sqlite.mobigroup.ru/src/wiki?name=tclsqlite But the problem is internal logical inconsistency in datatyping. As example in PostgreSQL there is no this problem: $ psql -h localhost --cluster 8.1/testing -U postgres template1 template1=> select 1='1'; ?column? ---------- t (1 row) -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
