[MDEV-30650] JSON output routines do not check the validity of strings in the same way that JSON_VALID() does. Created: 2023-02-14  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.4, 10.5, 10.6, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.4, 10.5, 10.6, 10.11

Type: Bug Priority: Major
Reporter: Rex Johnston Assignee: Rex Johnston
Resolution: Unresolved Votes: 0
Labels: 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.
Generated at Thu Feb 08 10:17:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.