Error copy table

Hi, i tried to make a copy of the table but I got this error. See attachment. With Windows, the copy works. It doesn't work with Linux.

Linux version HeidiSql 12.11.1.167 Win versione HeidiSql 12.10.0.7024

Thanks

You need to provide more details when reporting issues.

Please post

• a screenshot of the copy-table dialog,
• the CREATE code for the original table
• and the MariaDB version.

Hi, i'll take some screenshots for you so you can see the little flaws.

MariaDB Ver: 10.11.11

I tried to create a table in MariaDB 11.4 and the problem is the same.

Thanks

Please the CREATE code in text. Just run "SHOW CREATE TABLE mytable" and copy/paste the result here.

Creating a table works, but I used the wrong COLLATE type. If I try to add a column, I get the error you see.

When i copy a table i get this error

Please run SHOW CREATE TABLE test; in a query tab and copy the result here.

I have this result

Where's the problem with text? Please right-click the field with "CREATE TABLE..." and click copy, and paste here.

No problem

CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

I can confirm the issue in the Linux version, and already fixed it for the next release.

I also created issue #2222 with a description of the problem.

Ok! I opened a fix for the column list when writing a query.

Thanks