We have the following query:
CREATE TABLE t (
INSERT INTO t () VALUES ();
SELECT * from t;
Behind the scenes MariaDB (by default) expands timestamp column type to be:
timestamp DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP
. We are considering changing this behaviour. You can vote on your desired outcome here.