Bug #83274 new ROLE keyword in MySQL 8 can't use used like other keywords in a CREATE DDL

• Submitted: 5 Oct 2016 17:54
• Modified: 26 Jan 2017 6:14
• Reporter: Justin Swanhart
• Status: Closed
• Category: MySQL Server: DDL
• Severity: S1 (Critical)
• Version: 8
• OS: Any
• CPU Architecture: Any

[5 Oct 2016 17:54] Justin Swanhart

Description:
This works on MySQL 5.7:
create table t1(user varchar(64),date date, role varchar(64));

user and date are reserved words, and they work in DDL in both 5.7 and 5.8, but ROLE can't be used in a CREATE TABLE (or other expression) unless you place it in backticks (or quotes with ANSI_QUOTES).

This broke PS_History installation on MySQL 8, because P_S tables use role as a column name.  I had to add backtick quoting to all column names in PS_History (which was a good idea anyway).

How to repeat:
see above

[6 Oct 2016 6:49] MySQL Verification Team

Hello Justin,

Thank you for the report.

Thanks,
Umesh

[26 Jan 2017 6:14] Erlend Dahl

Fixed in 8.0.1.