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 Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: DDL Severity:S1 (Critical)
Version:8 OS:Any
Assigned to: CPU Architecture:Any

[5 Oct 2016 17:54] Justin Swanhart
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.

[26 Jan 2017 6:14] Erlend Dahl
Fixed in 8.0.1.