On Thu, Nov 17, 2016 at 09:54:01AM -0500, Richard Hipp wrote: > Standard SQL requires an implied NOT NULL on all PRIMARY KEY columns. > But due to a coding error, early versions of SQLite did not enforce > that, and so we have taken care not to enforce it on all subsequent > versions of SQLite to preserve backwards compatibility. > > WITHOUT ROWID tables were added later, and so NOT NULL is properly > enforced on all PRIMARY KEY columns in WITHOUT ROWID tables.
I've noticed this, and I'm quite happy about it. A [persistent] pragma to make SQLite3 adhere more strictly to the standard would be nice. You could slowly add more strictness. Anyone who turns on strictness would be getting what they asked for as subsequent add more. Nico -- _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
