Bug: "CREATE code" puts CURRENT_TIMESTAMP after DEFAULT in quotes

freejay's profile image freejay posted 10 months ago in General Permalink

Hello,

in the "CREATE code" output CURRENT_TIMESTAMP is put in quotes after DEFAULT but (correctly) not after ON UPDATE (see below).

The quotes are wrong and that statement doesn't work. Therefore copying a table with this doesn't work either.

Example

If I use the CREATE TABLE command of MySQL it works fine:

Description

Would be nice, if you could fix this in one of the next releases.

Thanks & best regards

Freejay

ansgar's profile image ansgar posted 10 months ago Permalink

Thanks for the hint with default/update. I am aware of the issue, and will fix this very soon.

freejay's profile image freejay posted 10 months ago Permalink

👍

Additional info:

This also leads to problems when you create a new table column with type TIMESTAMP. Then:

leads to

and also can't be saved:

ansgar's profile image ansgar posted 10 months ago Permalink

Should be fixed in the next build, available in one hour.

See official ticket #1910 for more details.

Please login to leave a reply, or register at first.