Re: [sqlite] Bug: Text compare doesn't work, if column name matches text literal enclosed in double quotes

Hello, this is apparently not a bug. I have just read, that double quoted strings are identifiers and no string literals... (https://sqlite.org/lang_keywords.html) Kindly Regards, Andreas Martin 2017-04-19 13:46 GMT+02:00 Andreas Martin : > Hello, > > I'll report a bug tested on

[sqlite] Bug: Text compare doesn't work, if column name matches text literal enclosed in double quotes

RE 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 l