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

Crash with Explain extended when using limit rows examined

    XMLWordPrintable

Details

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

    Description

      The dataset

      create table t1 (c1 char(2));
      create table t2 (c2 char(2));
      insert into t1 values ('bb'), ('cc'), ('aa'), ('dd');
      insert into t2 values ('bb'), ('cc'), ('dd'), ('ff');
       
      explain extended
      select * from t1, t2 where c1 = c2 LIMIT ROWS EXAMINED 2;
      

      Another question would be do we want to add ROWS EXAMINED to also show when we print the limit clause during explain exteded.

      Attachments

        Issue Links

          Activity

            People

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