DROP DATABASE IF EXISTS MCOL5535;
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;
i	x
1	0000-00-00 00:00:00
2	NULL
3	2024-01-01 01:01:01
UPDATE t1 SET x='0000-00-00 00:00:00' WHERE i = 3;
SELECT * FROM t1;
i	x
1	0000-00-00 00:00:00
2	NULL
3	0000-00-00 00:00:00
DROP DATABASE MCOL5535;