[MDEV-39720] Optimizer Trace doesn't quote string values, may have invalid JSON - Jira

XML

Word

Printable

Run this mtr testcase:

create table t2 (

  a varchar(100)

);

set optimizer_trace=1;

explain

select * from t2 where a < '"';

set @trace=(select trace from information_schema.optimizer_trace);

select json_valid(@trace);

select @trace;

drop table t2;

You will get:

select json_valid(@trace);

json_valid(@trace)

This is because strings are not quoted when they are written into JSON:

            "condition_processing": {

              "condition": "WHERE",

              "original_condition": "t2.a < '"'",

is duplicated by

MDEV-39632 Optimizer Trace Produces Invalid JSON for Quoted Table Alias

relates to

MDEV-30354 Optimizer trace does not escape double quotes, produces invalid JSON

MDEV-39768 Optimizer trace should use utf8mb4.

MDEV-39412 Failed to parse saved optimizer context: error reading ranges value

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.