Works as advertised. "Description" (with double quotes) is a field name. 'Description' with single quotes is a string constant.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dale Mellor Gesendet: Mittwoch, 28. November 2018 06:42 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Bug? Confused data entry with column name >>>>>>>> THIS VERSION SQLite 3.25.3 2018-11-05 20:37:38 89e099fbe5e13c33e683bef07361231ca525b88f7907be7092058007b750alt1 zlib version 1.2.8 gcc-8.2.0 >>>>>>>>> THIS SCRIPT create table test (id varchar, description varchar); insert into test (id, description) values ("Description", "Duh"); insert into test (id, description) values ("Daft", "Daft"); select rowid, * from test where id="Description"; >>>>>>>>>> PRODUCES 2|Daft|Daft >>>>>>>>>> BUT EXPECTED 1|Description|Duh ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
