Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
None
Description
JSON output strings need checking in the same manner as the check performed by JSON_VALID().
Unicode. Currently UTF8mb3:
MariaDB [test]> show create table information_schema.optimizer_trace\G
|
*************************** 1. row ***************************
|
Table: OPTIMIZER_TRACE
|
Create Table: CREATE TEMPORARY TABLE `OPTIMIZER_TRACE` (
|
`QUERY` longtext NOT NULL,
|
`TRACE` longtext NOT NULL,
|
`MISSING_BYTES_BEYOND_MAX_MEM_SIZE` int(20) NOT NULL,
|
`INSUFFICIENT_PRIVILEGES` tinyint(1) NOT NULL
|
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=0
|
1 row in set (0.004 sec)
|
(maybe we should change that to be UTF8MB4 in the next versions...)
Some characters need to be escaped, according to https://www.json.org/json-en.html, see the production for String.