Kurt Welgehausen <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > Saying NOT NULL on a PRIMARY KEY is redundant, by the way. > > -- > > D. Richard Hipp <[EMAIL PROTECTED]> > > sqlite> insert into t (k, d) values (null, 'jkl'); > sqlite> select * from t; > k d > ---------- ---------- >> <> jkl > > > Am I missing something, or should I write a bug ticket > about a primary key accepting nulls? >
To my surprise (perhaps "horror") I find that SQLite has for a very long time allowed NULL values in PRIMARY KEY columns. This is clearly incorrect. But the ability to do this has been in the code for so long that I fear changing it might break many legacy programs. So I have chosen to merely document the behavior for now - with a warning to developers that the behavior might be fixed in the future. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------