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

Index push down is not reflected in optimizer trace

    XMLWordPrintable

    Details

      Description

      create table t1 (a int primary key, b int);
      insert into t1 values (1,1),(2,2),(3,3);
       
      create table t2 (a int primary key, b int);
      insert into t2 values (1,1),(2,2),(3,3),(4,4);
       
       
      set optimizer_trace=1;
      SELECT * FROM t1 LEFT JOIN t2 ON t2.a=t1.a WHERE t2.b < 5;
      select * from information_schema.optimizer_trace;
      explain extended
      SELECT * FROM t1 LEFT JOIN t2 ON t2.a=t1.a WHERE t2.b < 5;
       
      drop table t1,t2;
      

        Attachments

          Activity

            People

            Assignee:
            varun Varun Gupta
            Reporter:
            sanja Oleksandr Byelkin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: