Hello, I'll report a bug tested on SQLite 1.18.0, Windows 7/64bit:
(You can reproduce this issue by using the attached SQL text file "bug.sql"). The bug appears, when querying from a table with text compare, where a column is named as like the text pattern: SELECT * FROM tbl WHERE col_1="col_2"; The result is empty, if there exists a column named "col_2". Using single quotes fixes this: SELECT * FROM tbl WHERE col_1='col_2'; Kindly regards, Andreas Martin _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
