On Tue, Sep 24, 2013 at 2:02 PM, Petite Abeille <[email protected]>wrote:
> > On Sep 24, 2013, at 7:59 PM, Dan Kennedy <[email protected]> wrote: > > > A double quoted string is treated as a column name if possible, or a > > string literal otherwise. It's an SQL thing. > > Nah. The second part is a SQLite thing. Randomly converting identifiers > into literals is more of a misfeature. > It was originally intended as a feature to provide enhanced MySQL compatibility, since MySQL used to *require* double-quotes on strings. Yes, it is something of a misfeature now, but we cannot change it without breaking backwards compatibility. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
