Bug #37059 Errors during "Forward Engineer Schema" for Inserts date for TIMESTAMP columns

Submitted: 29 May 2008 9:34 Modified: 8 Aug 2008 16:25
Reporter: Bernhard Wellhoefer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.22 OS:Windows (XP SP2)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[29 May 2008 9:34] Bernhard Wellhoefer
Description:
I have a simple table with author/user data and the table has on named 'lastLoginAt' column of type TIMESTAMP.

When I now add some Inserts data like '2008-05-05 12:34:56' and then try to run the "Forward Engineer Schema", I run into errors. Here an extraction of the advanced log:

INSERT INTO `author` (`idAuthor`, `login`, `password`, `first`, `last`, `email`, `lastLoginAt`) VALUES (1, 'bernd', 'bernd', 'Bernhard', 'Wellhöfer', 'bernhard.wellhoefer@gaia-group.com', 2008-05-05)
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '23:59:00)' at line 1

INSERT INTO `author` (`idAuthor`, `login`, `password`, `first`, `last`, `email`, `lastLoginAt`) VALUES (2, 'hanik', 'hanik', 'Michael', 'Hanik', 'michael.hanik@gaia-group.com', 2008-05-01 23:59:00)
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'stephan', 'Stephan', 'Jätzold', 'stephan@jaetzold.de', 2008-05-29 11:27:06);

How to repeat:
Create such a column, enter some Inserts data and try to fill the database.
[29 May 2008 10:04] Johannes Taxacher
As a workaround, you can either enter the values quoted or use a numerical style (like 20080505123456) then they are accepted in the insert-statement.
We don't auto-quote values in TIMESTAMP columns now because you can also use numerical values or keywords.
We consider improving that like its handeled now for i.e. varchar columns.
[7 Aug 2008 14:38] Johannes Taxacher
inserts-editor (as well as columns editors default column) now auto-quote datatype values correctly.
fix will be in 5.0.24.
[8 Aug 2008 16:25] Tony Bedford
An entry was added to the 5.0.24 changelog:

Errors were generated in SQL code during Forward Engineer Schema for Inserts data in TIMESTAMP columns.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.