On Mon, Apr 21, 2014 at 1:38 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 21 Apr 2014, at 6:18pm, Richard Hipp <d...@sqlite.org> wrote: > > > SQLite does the right thing and enforces NOT NULL on PRIMARY KEY for the > > newer WITHOUT ROWID tables. But long ago there was a bug that prevented > > enforcement NOT NULL on PRIMARY KEY of ordinary tables and by the time > the > > bug was discovered we couldn't really fix it without breaking lots of > > legacy. > > Can it be fixed in SQLite4 ? Can 'NOT NULL' be assumed for PRIMARY KEYs > in SQLite4 ? > > > Yes. Already fixed. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
