From "Enhance ALTER TABLE<https://www.sqlite.org/draft/lang_altertable.html> so
that it recognizes "true" and "false" as valid arguments to DEFAULT" introduced
in 3.24.0
A TEXT field can no longer have "true"/"false" default values.
The smart DEFAULT conversion should not be triggered if the hint is TEXT.
Although SQLite is typeless, table datatype hint could be use in this use
scenario.
Steps to reproduce
sqlite> CREATE TABLE "Table_1" ([ID] TEXT DEFAULT "false", [Field_1] TEXT NULL);
sqlite> insert into "Table_1" (Field_1) VALUES ("test");
sqlite> select * from Table_1;
0|test
Expected result
false|test
Christian Nols
Software Engineer
________________________________
christian.n...@mcl-technologies.com
Tel : + 32 2 724 35 19
MCL
NYSDAM Building
avenue Reine Astrid 92, 3rd floor
1310 La Hulpe- Belgium
BCE registered number 2.087.817.310
Tel : + 32 2 724 35 00 - Fax : + 32 2 724 35 04
www.mcl-collection.com<http://www.mcl-collection.com/>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
