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

Optimizer trace support for multi-table UPDATE and DELETE

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4
    • Fix Version/s: 10.4.3
    • Component/s: Optimizer
    • Labels:
      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

              • Assignee:
                varun Varun Gupta
                Reporter:
                psergey Sergei Petrunia
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: