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

Optimizer trace for DELETE query shows table:null

    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

      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);
       
      set optimizer_trace=1;
      explain delete from t10 where t10.a<3;
      select * from information_schema.optimizer_trace\G 
      

      prints

      *************************** 1. row ***************************
                                  QUERY: explain delete from t10 where t10.a<3
                                  TRACE: {
        "steps": [
          {
            "table": null,
            "range_analysis": {
              "table_scan": {
                "rows": 10,
                "cost": 5.1
              },
              "potential_range_indexes": [
      
      

        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: