Description
SHOW CREATE TABLE:
row_change_sequence_id bigint(20) unsigned NOT NULL DEFAULT nextval(test.users.row_change_sequence)
HeidiSQL CREATE preview for the same table:
row_change_sequence_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT
Heidi seems to treat the column as auto increment overall.
HeidiSQL version and OS
12.21.0.7344 Windows 11
Database server version
10.5.29-MariaDB
Reproduction recipe
CREATE SEQUENCE test_sequence;
CREATE TABLE test (
row_change_sequence_id bigint(20) unsigned NOT NULL DEFAULT nextval(test_sequence)
) ENGINE=MyISAM;
Error/Backtrace
Description
SHOW CREATE TABLE:
row_change_sequence_idbigint(20) unsigned NOT NULL DEFAULT nextval(test.users.row_change_sequence)HeidiSQL CREATE preview for the same table:
row_change_sequence_idBIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENTHeidi seems to treat the column as auto increment overall.
HeidiSQL version and OS
12.21.0.7344 Windows 11
Database server version
10.5.29-MariaDB
Reproduction recipe
CREATE SEQUENCE test_sequence;
CREATE TABLE
test(row_change_sequence_idbigint(20) unsigned NOT NULL DEFAULT nextval(test_sequence)) ENGINE=MyISAM;
Error/Backtrace