Bug #80577 Bug on Forward Engineer process - Disapproved zero value input
Submitted: 2 Mar 2016 0:25 Modified: 2 Mar 2016 5:37
Reporter: D S Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:6.3.4, 6.3.6 OS:Microsoft Windows (Microsoft Windows 10 Education)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[2 Mar 2016 0:25] D S
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'.
[2 Mar 2016 5:37] Umesh Shastry
Hello!

Thank you for the report and repeatable steps.
Verified as described with WB 6.3.6 on Win7.

Thanks,
Umesh