--disable_warnings
DROP DATABASE IF EXISTS MCOL5535;
--enable_warnings

CREATE DATABASE MCOL5535;

USE MCOL5535;

CREATE TABLE t1(i INTEGER, x DATETIME) ENGINE=COLUMNSTORE;

INSERT INTO t1 (i, x) VALUES (1, '0000-00-00 00:00:00'), (2, NULL), (3, '2024-01-01 01:01:01');

SELECT * FROM t1;

UPDATE t1 SET x='0000-00-00 00:00:00' WHERE i = 3;

SELECT * FROM t1;

DROP DATABASE MCOL5535;