bug in 5174?

amr posted 12 months ago in General

MariaDB 10.2.x converts this: create table t1 (ts timestamp default current_timestamp on update current_timestamp); ...to this create table t1 (ts timestamp default current_timestamp() on update current_timestamp());

which is displayed, and used, ok by the server. HeidiSQL displays the result as: create table t1 (ts timestamp default current_timestamp);

...presumably because of the function brackets. It does, however, export it correctly, so it is only the display that appears incorrect.

jpyy posted 12 months ago

Also columns having default values curtime() or curdate() are shown incorrectly in HeidiSQL. Please see MariaDB JIRA - MDEV-13377.

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