[EMAIL PROTECTED] wrote: > Saying NOT NULL on a PRIMARY KEY is redundant, by the way. > -- > D. Richard Hipp <[EMAIL PROTECTED]>
**kaw<~/tdpsa>$ sqlite3 Loading resources from /home/kaw/.sqliterc SQLite version 3.3.7 Enter ".help" for instructions sqlite> .nullvalue '<>' sqlite> create table t (k int primary key, d char); sqlite> insert into t (k, d) values (1, 'abc'); sqlite> insert into t (k, d) values (1, 'def'); SQL error: column k is not unique sqlite> insert into t (k, d) values (null, 'ghi'); sqlite> insert into t (k, d) values (null, 'jkl'); sqlite> select * from t; k d ---------- ---------- 1 abc <> ghi <> jkl Am I missing something, or should I write a bug ticket about a primary key accepting nulls? Regards ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
