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
0
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) VALUE
2 matches
Mail list logo