Bug #79432 | ALTER TABLE sometimes converts TEXT to JSON without syntax checking | ||
---|---|---|---|
Submitted: | 27 Nov 2015 8:14 | Modified: | 2 Dec 2015 12:49 |
Reporter: | Knut Anders Hatlen | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: JSON | Severity: | S3 (Non-critical) |
Version: | 5.7.9 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | json |
[27 Nov 2015 8:14]
Knut Anders Hatlen
[27 Nov 2015 8:16]
Knut Anders Hatlen
Originally reported here: http://ocelot.ca/blog/blog/2015/11/26/standard-sqljson-and-mysql-5-7-json/
[2 Dec 2015 12:49]
Jon Stephens
Fixed in MySQL 5.8.0. Documented in the 5.8.0 changelog as follows: Syntax checks were not always performed when an ALTER TABLE changed a column's type from TEXT to JSON. This could lead to JSON columns containing invalid JSON data. This issue was observed when the original TEXT column used the utf8mb4_bin collation. Closed.
[2 Dec 2015 18:19]
Jon Stephens
Also fixed in MySQL 5.7.11, and noted in the relevant changelog. Status unchanged.