Bug #102824 | JSON_TABLE's check for duplicate column names is case-sensitive | ||
---|---|---|---|
Submitted: | 5 Mar 2021 10:33 | Modified: | 13 Apr 2021 18:53 |
Reporter: | Knut Anders Hatlen | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: JSON | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[5 Mar 2021 10:33]
Knut Anders Hatlen
[27 Apr 2021 0:30]
Jon Stephens
Documented fix as follows in the MySQL 8.0.27 changelog: JSON_TABLE() allowed duplicate column names if the names differed in case only, although column names are case-insensitive in MySQL. Now this function compares column names in case-insensitive fashion. Also noted this change in the description of the function in the 8.0 Manual. Closed.
[16 Sep 2021 20:18]
Jon Stephens
BUG#104935 is a duplicate of this bug.