MySQL Bugs: #90059: Change type of mysql.dd_properties.properties to MEDIUMBLOB

Bug #90059	Change type of mysql.dd_properties.properties to MEDIUMBLOB
Submitted:	14 Mar 2018 10:24	Modified:	22 Mar 2018 13:48
Reporter:	Sivert Sørumgård	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S3 (Non-critical)
Version:	8.0.11	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
We should change the type of the 'properties' column in the DD table 'mysql.dd_properties' from 'MEDIUMTEXT' to 'MEDIUMBLOB' to avoid a dependency on the utf8 charset. This table is supposed to have an immutable definition, so this change will make it easier to remove the utf8 (aka utf8mb3) at a later stage.

How to repeat:
.

Suggested fix:
Change the table definition and re-record the dd schema related MTR tests.

Posted by developer:
 
Fixed in 8.0.12.

Internal change; no user-visible implications. No changelog entry needed.