MySQL Bugs: #112070: mysql-workbench does not handle database comment field

Bug #112070	mysql-workbench does not handle database comment field
Submitted:	15 Aug 2023 7:56	Modified:	16 Aug 2023 12:26
Reporter:	Kamil Cukrowski (OCA)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	MySQL Workbench CE (GPL) 8.0.34 CE build	OS:	Linux (ArchLinux)
Assigned to:		CPU Architecture:	x86 (x86_64)

Description:
mysql-workbench does not handle COMMENT in schema. It is not possible to set a comment for schema. It is not possible to "Alter schema..." on a database with a comment.

Also, it is not possible to set a comment when altering a table. The comments field exists https://github.com/mysql/mysql-workbench/blob/6e135fb33942123c57f059139cbd787bea4f3f9b/plu... , but is greyed out.

How to repeat:
Start mariadb database.
CREATE DATABASE test COMMENT 'this is a comment';
Click "Alter Schema..." in mysql workbench.
A popup message will appear.

    Error Parsing DDL for `test`.`test`.

    There was an error while parsing the DDL retrieved from the server. do you want to view the DDL or cancel processing it

    "View DDL" "Cancel"

After viewing the DDL you'll see:

     delimiter $$

     CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */ COMMENT 'this is a comment'$$

Suggested fix:
Would be great to add support for COMMENT field in databases, so that we can view and edit databases comments in mysql-workbench.

Hello!

Thank you for the feature request!
Imho this is duplicate of Bug #25370, please see Bug #25370.

Regards,
Ashwini Patil