[MDEV-25770] ANALYZE FORMAT=JSON $stmt - invalid JSON Created: 2021-05-25  Updated: 2022-01-02

Status: Open
Project: MariaDB Server
Component/s: JSON, Optimizer
Affects Version/s: 10.4.19
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Neil Pearce Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Windows 10

Attachments: File analyze_sort_key.sql    
Issue Links:
Relates
relates to MDEV-16462 EXPLAIN FORMAT=JSON produces illegal ... Stalled

 Description   

The "sort_key" in a "filesort" can be invalid - mismatched quotes:

 "query_block": {
 
    "select_id": 1,
 
    "r_loops": 1,
 
    "r_total_time_ms": 0.1429,
 
    "filesort": {
 
      "sort_key": "clubs."name"",
 
      "r_loops": 1,
 
      "r_total_time_ms": 0.0156,

Also, "table" is a duplicate key, making it difficult to process.
Generated at Thu Feb 08 09:40:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.