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

Make EXPLAIN show filtered and partitions columns

    XMLWordPrintable

Details

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.1
    • Optimizer
    • None

    Description

      MDEV-10000 adds EXPLAIN FOR CONNECTION for compatibility with MySQL-8.

      In MySQL-8, EXPLAIN FOR CONNECTION produces filtered and partitions columns. This means that anybody using EXPLAIN FOR CONNECTION syntax will expect these columns.

      On the other hand, in MariaDB, regular EXPLAIN and SHOW EXPLAIN do not show the extra columns.

      How can we be consistent across all commands? The solution is to first do what MySQL 5.7 did:

      • make the EXPLAIN command produce partitions and filtered columns.
      • then, make SHOW EXPLAIN and EXPLAIN FOR CONNECTION produce them, too.

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.