On January 11, 2019 7:03:03 AM EST, Christian Nols <[email protected]> wrote: >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 >________________________________ >[email protected] >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 >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
The default should be defined as string 'true', not identifier "true". -- J. King _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
