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

Make the main testsuite runnable with optimizer trace enabled

    XMLWordPrintable

Details

    Description

      This is a part of MDEV-23766.

      One can run the entire main testuite with optimizer trace enabled like so:

       ./mysql-test-run --suite=main --mysqld=--optimizer_trace=enabled=on
      

      On a 10.5-based tree, it fails just one test for me:

      CURRENT_TEST: main.opt_trace
      --- /optane/dev-git2/10.5-opt-trace-fix/mysql-test/main/opt_trace.result        2021-10-22 17:44:19.947288399 +0300
      +++ /optane/dev-git2/10.5-opt-trace-fix/mysql-test/main/opt_trace.reject        2021-10-22 18:05:12.727056238 +0300
      @@ -6,7 +6,7 @@
       OPTIMIZER_TRACE        INSUFFICIENT_PRIVILEGES
       show variables like 'optimizer_trace';
       Variable_name  Value
      -optimizer_trace        enabled=off
      +optimizer_trace        enabled=on
       set optimizer_trace="enabled=on";
       show variables like 'optimizer_trace';
       Variable_name  Value
       
      mysqltest: Result length mismatch
      
      

      If we can get that test to pass, we can get the buildbot to run this.

      We can run non-main testsuites as well, but this is considered to have less benefit.

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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