Bug #69217 Workbench model will not accept DATE, TIME, YEAR, TIMESTAMP for a column
Submitted: 13 May 2013 16:16 Modified: 13 May 2013 19:47
Reporter: José Gabriel González Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.2.47 CE OS:Windows
Assigned to: CPU Architecture:Any

[13 May 2013 16:16] José Gabriel González 
Description:
When attempting to configure a column as either DATE, TIME, YEAR, TIMESTAMP an error message is displayed saying:

'The given data type

TIMESTAMP

contains errors and cannot be accepted. The previous value is kept instead.'

This occurs when attempting to add a new column or edit an existing column.  The same behaviour occurs in both the model overview screen and in the EER Diagram screen.

This options (DATE, TIME, YEAR, TIMESTAMP) should be in the list of the column type.

How to repeat:
Fairly simple, as per description (no code sample possible because the bug is centred on GUI behaviour)
[13 May 2013 16:19] José Gabriel González 
Workbench model will not accept TIMESTAMP

Attachment: mysqlworkbeanch_error.bmp (image/bmp, text), 1.05 MiB.
[13 May 2013 19:05] MySQL Verification Team 
Thank you for the bug report. Please check duplicate with http://bugs.mysql.com/bug.php?id=68191 . Thanks.
[13 May 2013 19:40] José Gabriel González 
Yes, I saw it, and then... there are even reports since 2012 of this same bug, When can we have the solution?
[13 May 2013 19:47] MySQL Verification Team 
Thank you for the feedback.
[4 Jun 2015 19:10] Steven Henley 
To be specific, the EER Diagram will show the DateTime fields but the Overview Model will not.
[12 Oct 2018 6:44] Parthasarathy Mandayam 
If you use DATETIME or TIME instead of DATETIME() or TIME() it works
You should change the dropdown in design interface ti show DATETIME and TIME instead of DATETIME() and TIME()