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

[2 Aug 2019 14:44] Susan Koerner
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.
[20 Aug 2019 17:50] Paul DuBois
Posted by developer:
 
Fixed in 8.0.18.

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