Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
MariaDB [(none)]> use test;
Database changed
MariaDB [test]> create table t1(d1 date) engine=myisam;
Query OK, 0 rows affected (0.01 sec)
MariaDB [test]> insert into t1 values (.1);
Query OK, 1 row affected, 1 warning (0.00 sec)
MariaDB [test]> select * from t1;
------------
d1 |
------------
0000-00-00 |
------------
1 row in set (0.00 sec)
MariaDB [test]> drop table t1;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test]> create table t1(d1 date) engine=columnstore;
Query OK, 0 rows affected (0.26 sec)
MariaDB [test]> insert into t1 values (.1);
Query OK, 1 row affected, 1 warning (0.22 sec)
MariaDB [test]> select * from t1;
------
d1 |
------
NULL |
------
1 row in set (0.06 sec)
Attachments
Issue Links
- is duplicated by
-
MCOL-171 0000-00-00 dates are not supported and are munged to NULL with no warnings
- Closed