On Mon Oct 12, 2009 at 02:54:38PM +0200, Robert Roggenbuck wrote: > I detected that it is possible to enter NULL in a table-column defined as > PRIMARY KEY. Is it a bug or a feature of the "manifest typing" of SQLite? > Or is there something in DBD::SQLite going wrong?
Most likely a 'feature' of SQLite. Running your code manually: sqlite> CREATE TABLE TestTable ( ...> a INTEGER PRIMARY KEY, ...> b INTEGER NOT NULL, ...> c INTEGER ...> ); sqlite> INSERT INTO TestTable VALUES (NULL, 1, NULL); sqlite> select * from TestTable; 1 1 NULL Reading http://www.sqlite.org/autoinc.html it appears that SQLite has an automatic 'autoincrement' feature. Why it converts NULL into auto is beyond me. I would try perhaps try the same question at: http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Cheers, Mark. -- Mark Lawrence