Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\Masina\AppData\Roaming\MySQL\Workbench\log\wb.log]
Hi MySQL team,
I just started using MySQL Workbench, but suddenly I found bug.
On dev.mysql.com/doc/en/datetime.html you said "MySQL does not accept TIMESTAMP values that include a zero in the day or month column or values that are not a valid date. The sole exception to this rule is the special “zero” value '0000-00-00 00:00:00'", but I tried to use zero velue in Workbench and it was unsuccessful.
I supposed that you forgot to include this exception when developing Workbench, so I made minor changes with values, after which process of
How to repeat:
1. Add model diagram;
2. Import .sql file through Reverse Engineer SQL Script with Create TABLE code line inside file:
------`created_on` timestamp DEFAULT '0000-00-00 00:00:00',-----;
3. Finish the process >> Execute it;
4. Open Database > Forward Engineer menu;
5. Connect to database
6. You will receive Error 1067 - http://prntscr.com/aa2erw and you won't be able to finish the process;
7. If you change zero values to e.g. '2016-01-01 01:01:01', it will work - http://prntscr.com/aa2g7o.
Suggested fix:
Approve user to use “zero” value '0000-00-00 00:00:00'.