MySQL Bugs: #96416: 8.0.17 I_S.keywords table has reserved word ARRAY listed as unreserved

Bug #96416	8.0.17 I_S.keywords table has reserved word ARRAY listed as unreserved
Submitted:	2 Aug 2019 14:44	Modified:	20 Aug 2019 17:50
Reporter:	Susan Koerner	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S3 (Non-critical)
Version:	8.0.17	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
ARRAY and MEMBER were added as reserved keywords in 8.0.17. In the keywords table, ARRAY is noted as unreserved rather than reserved.

mysql> select @@version;
+-------------------+
| @@version         |
+-------------------+
| 8.0.17-commercial |
+-------------------+
1 row in set (0.00 sec)
mysql> select * from information_schema.keywords where word in ('ARRAY','MEMBER');
+--------+----------+
| WORD   | RESERVED |
+--------+----------+
| ARRAY  |        0 |
| MEMBER |        1 |
+--------+----------+
2 rows in set (0.01 sec)
mysql> 

How to repeat:
log in to a 8.0.17 server and check the values in information_schema.keywords for ARRAY.

Posted by developer:
 
Fixed in 8.0.18.

The ARRAY reserved word was listed as unreserved in the
INFORMATION_SCHEMA.KEYWORDS table.