On Thu, May 17, 2018 at 6:51 PM Richard Hipp <d...@sqlite.org> wrote:

> 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".
>

I think I'm not alone in wishing there was a way to disable all legacy
backward compatibility "warts".
Then again, that adds more "branches" and code complexity, which for SQLite
needs testing, given its high standards.
So I'm afraid that will remain wishful thinking. --DD
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to