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: | |
| 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
[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.