Users new to MariaDB often struggle with the default behavior of MariaDB regarding the datatype timestamp and automatic values https://mariadb.com/kb/en/timestamp/#automatic-values
explicit_defaults_for_timestamp , currently set to OFF by default, should be ON by default.
At the same time it should be checked if the variable can become a dynamic variable and if the scope SESSION can be added.
With explicit_defaults_for_timestamp=OFF (default):
With explicit_defaults_for_timestamp=ON the result would be:
MySQL did it in 8.0.2