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

./mtr --ps-protocol main.opt_trace fails to produce some traces

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.7(EOL), 10.8(EOL)
    • 10.6
    • Tests
    • None

    Description

      The recently added optimizer_trace option fails to produce any output for two EXPLAIN statements in 10.6, 10.7, 10.8. In 10.4 and 10.5, it works fine. The following change will ensure that the optimizer trace output is generated.

      diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test
      index 2077422fa1b..a516c2891a2 100644
      --- a/mysql-test/main/opt_trace.test
      +++ b/mysql-test/main/opt_trace.test
      @@ -48,12 +48,14 @@ create view v1 as select a from t1 group by b;
       create view v2 as select a from t2;
       
       --echo # Mergeable view
      +--disable_ps_protocol
       --optimizer_trace
       explain select * from v2 ;
       
       --echo # Non-Mergeable view
       --optimizer_trace
       explain select * from v1 ;
      +--enable_ps_protocol
       drop table t1,t2;
       drop view v1,v2;
       
      

      Attachments

        Activity

          People

            monty Michael Widenius
            marko Marko Mäkelä
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.