Antoine Caron wrote:
>
> I was expecting -1 instead of NULL as default value, can anyone explain me
> that ?
>
That looks like a bug in the table_info pragma. You should probably
report it.
The following test script shows that the correct default value is used
even though the an incorrect null value is displayed by the pragma.
sqlite> CREATE TABLE IF NOT EXISTS test_table
...> (test_field INT NOT NULL DEFAULT -1, two text);
sqlite> .mode column
sqlite> .header on
sqlite> PRAGMA table_info (test_table);
cid name type notnull dflt_value pk
---------- ---------- ---------- ---------- ---------- ----------
0 test_field INT 99 0
1 two text 0 0
sqlite> insert into test_table(two) values('one');
sqlite> select * from test_table;
test_field two
---------- ----------
-1 one
You can report the bug at
http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
