Using "create script as + create" generates an invalid script in dbForge Studio for MySQL
Using "create script as + create" generates an invalid script in dbForge Studio for MySQL
This happens when the default value on a field is currenttimestamp(6) ON UPDATE currenttimestamp(6)
Example of what gets generated.
CREATE TABLE test.junkola (
Id int(11) NOT NULL AUTOINCREMENT,
RowVersion datetime(6) NOT NULL DEFAULT 'CURRENTTIMESTAMP(6)' ON UPDATE CURRENT_TIMESTAMP (6),
PRIMARY KEY (Id)
)
The QUOTES around 'current_timestamp(6)' do not compile in your tool.
3
votes
David Angel
shared this idea
-
David Angel
commented
This is version 6.2.280 of dbForge Studio for MySQL (I just downloaded it)
-
David Angel
commented
It also fails to create a database schema correctly as all the columns with the 'current_timestamp(6)' are generated with single quotes and it does not compile.