Re: [sqlite] PRAGMA table_info and not nullable rowid alias

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.00 sys 0.00 sqlite> PRAGMA table_info(test); cid,name,type,notnull,dflt_value,pk

[sqlite] PRAGMA table_info and not nullable rowid alias

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)