That is because some daft person is using the wrong quotes, doh!
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Dale Mellor >Sent: Tuesday, 27 November, 2018 22:42 >To: sqlite-users@mailinglists.sqlite.org >Subject: [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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
