That's interesting. Apparentely PRAGMA table_info() reports the declared column type not the operational column type.
sqlite> CREATE TABLE test (id INTEGER PRIMARY KEY NOT NULL); Run Time: real 0.454 user 0.000000 sys 0.000000 sqlite> PRAGMA table_info(test); cid,name,type,notnull,dflt_value,pk 0,id,INTEGER,1,,1 On Sun, Jul 16, 2017 at 12:19 AM, gwenn <gwenn.k...@gmail.com> wrote: > Hello, > PRAGMA table_info reports that a rowid alias is nullable: > > sqlite> .headers on > sqlite> CREATE TABLE test (id INTEGER PRIMARY KEY); > sqlite> pragma table_info("test"); > cid|name|type|notnull|dflt_value|pk > 0|id|INTEGER|0||1 > sqilte> --0|id|INTEGER|1||1 expected > sqlite> INSERT INTO test (id) VALUES (NULL); > sqlite> SELECT rowid, id FROM test; > id|id > 1|1 > > Regards. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users