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

outer to inner joins 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

            psergei Sergei Petrunia
            sanja Oleksandr Byelkin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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