Bug #99599 Use standard table editor for table templates
Submitted: 16 May 2020 12:41 Modified: 15 Jun 2020 12:34
Reporter: Brad Lanier Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:8.0.20 OS:Any
Assigned to: CPU Architecture:Any
Tags: table editor, template, workbench

[16 May 2020 12:41] Brad Lanier
Current table templates in Workbench do not support many of the standard table characteristics that are able to be set/modifies with the table editor used elsewhere in Workbench. As an example, columns that are a core part of all tables in a database generally have a common set of indexes as well. Since index names are only unique to the table that they are created against and since their creation can be a part of the Create Table Statement, this capability should be an included part of table templates to make the template feature truly useful. Other examples include comments for columns, additional column flags, character sets, etc.  Also, new features to MySQL that are covered elsewhere within Workbench get overlooked when it comes to Table Templates (case in point, support for generated columns Bug #99558).

How to repeat:
See Description.

Suggested fix:
Recommend using the same table editor used elsewhere within Workbench for creating and editing Table Templates.
[15 Jun 2020 12:34] MySQL Verification Team
Hello Brad Lanier,

Thank you for the bug report and feedback.

Ashwini Patil
[30 Nov 2021 8:17] Emmanuel FOURNIER

When we use a lot of column's comment, it'll be great to set column's comment in the table's templates ;-)

New feature !

Best regards,