Faulty DEFAULT value for DATE columns that are NOT NULL
When inserting a DEFAULT value into a column that is of type DATE with the constraint NOT NULL, the value 00000-00-00
is inserted. This does not follow the date scheme and is not even insertable by hand.
Command to reprodruce:
echo 'CREATE DATABASE D; USE D; CREATE TABLE T (d DATE NOT NULL); INSERT INTO T VALUES (DEFAULT); SELECT * FROM T;' | build/debug_shared/bin/shell --plan-enumerator PEall
Edited by Tobias Kopp