Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
1.0.3
Description
create table t2(d date, dt datetime) engine=columnstore;
MariaDB [test]> insert into t2 values ('0000-00-00','0000-00-00');
Query OK, 1 row affected (0.25 sec)
MariaDB [test]> select * from t2;
----------+
| d | dt |
----------+
| NULL | NULL |
----------+
1 row in set (0.06 sec)
MariaDB [test]> select * from t2 where dt='0000-00-00';
Empty set (0.00 sec)
MariaDB [test]> select * from t2 where dt is null;
----------+
| d | dt |
----------+
| NULL | NULL |
----------+
1 row in set (0.01 sec)
