Bug #40189 | Table Editor - creating nullable TIMESTAMP columns | ||
---|---|---|---|
Submitted: | 20 Oct 2008 20:16 | Modified: | 20 Oct 2009 6:25 |
Reporter: | Greg Thomas | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL GUI Common | Severity: | S3 (Non-critical) |
Version: | 1.2.14 | OS: | Windows |
Assigned to: | CPU Architecture: | Any | |
Tags: | null, timestamp |
[20 Oct 2008 20:16]
Greg Thomas
[20 Oct 2008 20:17]
Greg Thomas
Screen shot showing table definition and incorrect SQL
Attachment: tableeditor.png (image/png, text), 38.92 KiB.
[20 Oct 2008 20:21]
Greg Thomas
Doh! I said >The column 'bar' should be defined as > > `bar` NULL TIMESTAMP, I of course meant >The column 'bar' should be defined as > > `bar` TIMESTAMP NULL,
[20 Oct 2008 20:24]
Greg Thomas
It's also worth noting that the "NULL" is also lost when editing that column, too.
[21 Oct 2008 0:05]
MySQL Verification Team
Thank you for the bug report. Could you please try the latest release 1.2.13 of MySL Administrator. Thanks in advance.
[25 Oct 2008 18:09]
Greg Thomas
Have retried with version 1.2.14 of MySQL Administrator, and this exhibits identical behaviour.
[31 Oct 2008 9:50]
Sveta Smirnova
Thank you for the report. Verified as described. Workaround: edit table, then check "not null" again. Please note TIMESTAMP field will have default CURRENT_TIMESTAMP in this case which is correct.
[20 Oct 2009 6:25]
Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL GUI tools into MySQL Workbench. We won't fix this anymore. More informations about MySQL Workbench you will find here: http://dev.mysql.com/workbench/