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

Make EXPLAIN show filtered and partitions columns

    XMLWordPrintable

    Details

    • Type: Task
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: 10.12
    • Component/s: Optimizer
    • Labels:
      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

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