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

Reply via email to