Simon Slavin wrote: > On 17 May 2019, at 1:33pm, Clemens Ladisch <clem...@ladisch.de> wrote: >> This keyword behaves magically.
... as far as the SQL standard is concerned. > Mmmm. In that case, to implement this properly you need to store > a default-type flag alongside the default value. The SQLite syntax diagrams treat it as "literal-value": <https://www.sqlite.org/syntax/column-constraint.html> SQLite's actual in-memory representation of default values is an expression tree; _all_ DEFAULT expressions are evaluated lazily. (SQL-92 does not allow arbitrary expressions as default values.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users