[sqlite] After update from 3.20 to 3.23 alter table throws error for boolean with default value FALSE

[heribert]

Hello,

after updating to release 3.23 the following sql-command do not work any 
longer

'alter table Inbox add column WasSend boolean default FALSE'
The command works with 3.20 upto now.
With 3.23 i got the error: 'Cannot add a column with non-constant default'

After changing FALSE to 0 the command works with sqlite 3.23.
'alter table Inbox add column WasSend boolean default 0'

So i looked into the SQLite keyword list... but i didn't find neither 
FALSE nor TRUE. So, why did the FALSE work with 3.20?

Thx
heribert



_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users