Bug #103506 Incorrect display of 'charset collection' during alter table
Submitted: 28 Apr 2021 0:30 Modified: 29 Apr 2021 23:40
Reporter: Mel Smith Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.24 OS:Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[28 Apr 2021 0:30] Mel Smith 
Description:
Affected features: "ALTER TABLE" and "COPY CREATE TABLE TO CLIPBOARD"

Alter Table:
Charset and collation are either blank or not displayed correctly during "alter table". 
When we select "alter table", the table's charset is correct, but collation is incorrect. We noted that charset & collation in the column definitions had also become blank. This poses a potential problem if we ever need to alter a table in future using workbench. 

Copy create table to clipboard:
Copies everything correctly except for 'charset' in the column definitions

How to repeat:
1. Create table:

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `testcol` varchar(45) CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `testcol1` mediumtext CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

2. Copy create table `test` to clipboard results in...

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `testcol` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `testcol1` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

NOTE that 'charset' is missing in the column definitions

3. Alter table `test`...

Correctly shows that the table is charset utf8mb4, but incorrectly displays collation as "utf8mb4_0900_ai_ci"

The columns now have blanks in the "charset" and "collation" fields
[29 Apr 2021 12:04] MySQL Verification Team 
Hello Mel Smith,

Thank you for the bug report.
Imho this is duplicate of Bug #92534, please see Bug #92534.

Regards,
Ashwini Patil
[29 Apr 2021 23:40] Mel Smith 
Hi Ashwini Patil

Thanks for the info, can we have an ETA on when this bug will be corrected? 

Regards
Mel