MySql Primary Key turns to Unique Index (new table)

I am using v10.3.0.5831, (released: 2019-12-11) when i try to create new table, The "Primary Key" that I added turns to a Unique index (called "PRIMARY").

this situation started to coexist with the last update.

Oh that sounds like issue #856, which I could not reproduce here.

Still cannot reproduce, neither on MySQL 5.7 nor on MariaDB 10.3. Which server is it on your side?

these are the screenshots..

these are the screenshots..

same as issue #856

I spent again half an hour to reproduce this issue, but again I failed

• downloaded MySQL 5.6.47 server, started it
• ensured I have the same sql_mode set: STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
• tried on MySQL 5.1
• tried on MariaDB 10.3
• created a new table via table designer
• created a table via SQL code from your screenshot (please paste text the next time)
• created a primary key via right-click on column Create > Primary key
• created a primary key via Add button on Indexes tab

All attempts give me a normal primary key, not a unique key:

I suspect the following query to return some non-standard strings on your server. Please run it and post the result here:

SHOW INDEXES FROM `testtable` FROM `allatpl`;

here is the result "SHOW INDEXES FROM testtable FROM allatpl;"

this screenshots maybe give hint

no issue with exporting table.

Ok thanks for the screenshots.

Is it the latest build you are using now? If not please update.

I am using the latest build, I always keep up to date. this problem started about 2 weeks ago, was not before

I uninstalled "heidisql" and installed it again. problem solved. the simplest solution :)

Ok, but you are now using the v10.3 release, not the latest build, or?

I downloaded and installed HeidiSQL 10.3 from https://www.heidisql.com/download.php. now i am using Version 10.3.0.5771 (released 2019-12-11), not the latest

Ok, that solves the issue for you, but leaves it broken in the latest build. I will have to find out why primary keys are not always detected as such.