Page 1 of 1

mysql default value

PostPosted: Mon Nov 30, 2015 11:21 am
by KiPSOFT

Re: mysql default value

PostPosted: Tue Dec 01, 2015 10:22 am
by Serge
I can't reproduce that.
Are you just setting new default value to "CURRENT_TIMESTAMP" (without quotes)?

Re: mysql default value

PostPosted: Wed Dec 09, 2015 2:32 pm
by KiPSOFT
Yes serge i'm sure. My value CURRENT_TIMESTAMP. My charset Turkish, this problem for default value ?

Re: mysql default value

PostPosted: Wed Dec 09, 2015 2:47 pm
by Serge
I don't think that it can be somehow related to charset.
Just in case - could you try to run DBeaver with parameter "-nl en" and check this issue again?
Also, check it in the recent version (3.5.6). There were some fixes related to default values.

Re: mysql default value

PostPosted: Thu Dec 10, 2015 10:21 am
by techouse
I can confirm this bug. DBeaver will put CURRENT_TIMESTAMP in single quotes and MySQL will treat it as a string not a special timestamp default value.

Re: mysql default value

PostPosted: Thu Dec 10, 2015 11:36 am
by KiPSOFT

Re: mysql default value

PostPosted: Thu Dec 10, 2015 1:53 pm
by Serge
I did reproduce that (at least for new columns).
Fix will be added in the next version.
Thanks for report!