Bug #109658 Test case about Bug#33148961
Submitted: 17 Jan 2023 7:45 Modified: 6 Feb 2023 9:59
Reporter: Huaxiong Song (OCA) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Data Dictionary Severity:S7 (Test Cases)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[17 Jan 2023 7:45] Huaxiong Song
Description:
Hi:
    I saw some changes made for the bug#33148961 in commit#I9e0962bd04248f9353a398c6d07385148ef49dea. And I have a few questions to ask:

    1. There are invalid comments in partition and sub-partition(table "t4" and "t5" on file [data_57_invalid_comment_string.zip]), but I cannot find a failing for those. I dropped t1,t2,t3 and p1, the server can upgrade successfully and remain the invalid comment in partition table and sub-partition table.
    2. I really want to know how you created a table with invalid comments, I tried many times but failed.

Thank you,

How to repeat:
unzip -qo data_57_invalid_comment_string.zip -d db

#mysql 5.7
start msyql 5.7 with datadir = db;
use test;
drop table t1;
drop table t2;
drop table t3;
drop procedure p1;
shutdown mysql 5.7

#mysql8.0
start msyql 8.0 with datadir = db;
[6 Feb 2023 9:59] MySQL Verification Team
Hello Huaxiong Song,

Thank you for the report.
Imho bugs database is not a place to discuss/get answers for your queries etc. 
You can try to use forums.mysql.com instead. Also, detailed explanation/commit details are already available here - https://github.com/mysql/mysql-server/commit/45018470d78ae1ccf3ed39c1fbbb32c1ed735102

regards,
Umesh