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

json_extract doesn't retrieve data from trace

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Optimizer
    • None

    Description

      Issue:

      ------------
      In Normal mtr run , json_extract retrieves data from trace.
      When run with --replay-server , it doesn't , so mtr test fails with result length mismatch

      For mtr output refer : mtr.out

      How to repro:

      ./mtr example.test --record
      ./mtr example.test //Test passes
      ./mtr example.test --replay-server //Test Fails
      

      mtr testcase to repro issue (Say example.test):

      --source include/not_embedded.inc
      --source include/have_sequence.inc
      create table t (c int, key (c));
      insert into t select seq from seq_1_to_10000;
      alter table t
        add column vc int as (c + 1),
        add index(vc);
      set @old_optimizer_trace=@@optimizer_trace;
      set optimizer_trace=1;
       
      ## order by
      explain select c + 1 from t order by c + 1;
      select json_extract(trace, '$**.virtual_column_substitution') from information_schema.optimizer_trace;
      drop table t;
      
      

      Attachments

        1. mtr.out
          3 kB
          Pavithra Pandith

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              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.