bug in 5174?

amr posted 8 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 8 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.