On 9/23/19, Keith Medcalf <kmedc...@dessus.com> wrote: > > due to a > longstanding bug in SQLite3 you can use identifier quotes around strings
I don't think "bug" is quite the right word here, as the behavior was deliberate. The use of double-quotes for strings was put in in a (perhaps misguided) attempt to be more compatible with MySQL 3.x, which was the predominant SQL engine when SQLite was first being designed. Maybe "mis-feature" would be a better word. In any event, you are correct that the behavior can now be disabled and should be for new applications. But we need to leave it turned on by default for legacy. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users