Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-42167

Too much escaping in optimizer trace

    XMLWordPrintable

Details

    • Can result in unexpected behaviour

    Description

      testcase:

      --source include/have_sequence.inc
      create table t1 (a varchar(10), key(a));
      insert into t1 select concat('x', seq) from seq_1_to_100;
      insert into t1 values ('a"1'), ('a"2'), ('a"3');
      set optimizer_trace='enabled=on';
      --sorted_result
      select a from t1 where a in ('a"1', 'a"2', 'a"3');
      select json_detailed(json_extract(trace, '$**.range_scan_alternatives[*].ranges'))
        as ranges
      from information_schema.optimizer_trace;
      drop table t1;
      

      gives

      select json_detailed(json_extract(trace, '$**.range_scan_alternatives[*].ranges'))
      as ranges
      from information_schema.optimizer_trace;
      ranges
      [
          [
              "(a\\\"1) <= (a) <= (a\\\"1)",
              "(a\"2) <= (a) <= (a\"2)",
              "(a\"3) <= (a) <= (a\"3)"
          ]
      ]
      

      Attachments

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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