Bug #96350 Upgrade Checker ignores reserved word MEMBER
Submitted: 27 Jul 2019 5:08 Modified: 12 Nov 2019 18:23
Reporter: Ryusuke Kajiyama Email Updates:
Status: Closed Impact on me:
None 
Category:Shell Upgrade Checker Severity:S3 (Non-critical)
Version:8.0.17 OS:Any
Assigned to: CPU Architecture:Any

[27 Jul 2019 5:08] Ryusuke Kajiyama 
Description:
Some Keywords and Reserved Words of MySQL 8.0 are properly detected in output #2 of Upgrade Checker, a reserved word MEMBER was ignored.
I haven't tested all those Keywords and Reserved Words.
At least ADMIN, EMPTY, GROUPS, WINDOW were detected correctly.

How to repeat:
e.g.

CREATE TABLE MEMBER(
id SERIAL,
MEMBER VARCHAR(32) CHARACTER SET utf8mb3)
ENGINE MyISAM
PARTITION BY HASH(id)
PARTITIONS 4;

Then run Upgrade Checker.

Suggested fix:
Test against all Keywords and Reserved Words.
[27 Jul 2019 5:44] MySQL Verification Team 
Hello Kajiyama-San,

Thank you for the report and feedback.

regards,
Umesh
[12 Nov 2019 15:27] Konrad Olesinski 
Posted by developer:
 
Member keyword was added with implementation of WL#13376 (8.0.18).
[12 Nov 2019 18:23] Margaret Fisher 
Posted by developer:
 
Added bug number to changelog entry for WL #13376 (8.0.18) and closed off.