Setting using DEFAULT CURRENT_TIMESTAMP not working in d1?

Developers D1
1

As of sqlite 3.1.0, sqlite supports columns with DEFAULT CURRENT_TIMESTAMP but I get the following error when trying to use it:

ERROR 9015: SQL engine error: failed to read next row: Cannot add a column wit│
 non-constant default [code: 7500]

Here’s an example of code that could trigger the error (e.g. in a migration file)

ALTER TABLE "users" ADD COLUMN created_at DATETIME DEFAULT CURRENT_TIMESTAMP;
2

Since this is still the top result on Google when looking for d1 and current_timestamp:

The issue seems to be resolved, DEFAULT CURRENT_TIMESTAMP now behaves exactly as you would expect (at least when creating a new table on the experimental backend)