bug in 5174?

[expired user #10889]'s profile image [expired user #10889] posted 7 years ago in General Permalink

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.

[expired user #10900]'s profile image [expired user #10900] posted 7 years ago Permalink

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.