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

Optimizer trace support for multi-table UPDATE and DELETE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.3
    • Optimizer
    • None

    Description

      Multi-table UPDATE/DELETE do not produce a trace at the moment. They should. I am not sure if there is anything specific to be added to the trace about them, just enabling the tracing so that one can see the optimization of their underlying join is good.

      create table ten(a int);
      insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
      create table t10 (a int, b int);
      insert into t10 select a,a from ten;
      alter table t10 add key(a);
      create table t11 like t10;
      insert into t11 select * from t10;
      explain delete t10,t11 from t10, t11 where t10.a=t11.a and t11.a<3;
      select * from information_schema.optimizer_trace\G
      

      Attachments

        Issue Links

          Activity

            People

              varun Varun Gupta (Inactive)
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.