Thanks.
-----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, May 17, 2018 12:52 PM To: SQLite mailing list Subject: Re: [sqlite] After update from 3.20 to 3.23 alter table throws error for boolean with default value FALSE On 5/17/18, David Raymond <david.raym...@tomtom.com> wrote: > So what confuses me is that I would think that what comes after "DEFAULT" > would have to be a string literal if it's not an identifier. So why does it > let you put something in there without needing to put it in quotes? There was a bug in an historical version of SQLite. We have to continue to support that buggy behavior. Otherwise, if you try to open a legacy database file with a newer version of SQLite it might report the legacy database is "corrupt". -- 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users