MySQL Bugs: #54987: import to model TIMESTAMP ON UPDATE CURRENT

Bug #54987	import to model TIMESTAMP ON UPDATE CURRENT_TIMESTAMP does not work
Submitted:	4 Jul 2010 16:48	Modified:	2 Sep 2010 16:33
Reporter:	not available	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.25	OS:	Linux
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	workbench timestamp on update

Description:
Timestamp columns with on update does not work in workbench

its not possible to create such column in diagram (there is default though)
its not possible to import it by syncing model with database column doesn't appear even

How to repeat:
CREATE TABLE t (ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);

import it by synchronize model option

Suggested fix:
add another option that would include ON UPDATE in similar way as DEFAULT

I was able to reverse engineer database with your table t successfully (on Mac, so this can be Linux-related problem), and I see CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP  in DEFAULT field. 

So, had you tried to enter "CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP" in DEFAULT field for the column? For me it works, and proper SQL is generated.

the other way is a problem for me

I couldn't repeat doing reverse engineer on Fedora 13 X86_64 and Windows Vista.

Many thanks for writing a bug report.

I made tests here with both directions:

1. in modeling create timestamp column and say default current_timestamp on update current_timestamp

Sync this and it end up correct in database system.

2. in database system create such a table with such a column ... sync it and it showed up correct in modeling. In column row at default field you will find:
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP.

What is missing here is a nice button or check box for ON UPDATE at the column editor. This would be a nice feature request and so I will set this bug to feature request.

Added Default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP  to context menu

this has been included in 5.2.26

An entry has been added to the 5.2.26 changelog:

Added default value of CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP to context menu of column editor for TIMESTAMP columns.