Doesn't look like the formatting worked on the last one.
Just an quick example using the sqlite3 CLI:db=/tmp/test.dbsqlite3 $db "create 
table t(id integer primary key,ts text default 
(datetime('localtime','now')));"for x in "'no_date'" "'invalid_date'" "NULL" 
"CURRENT_TIMESTAMP" "DEFAULT"; do????sqlite3 $db "insert into t(ts) 
values($x);"donesqlite3 $db "select * from t;"
Error: near "DEFAULT": syntax error1|no_date2|invalid_date3|4|2015-11-24 
19:06:26

Reply via email to