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

Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN

Details

    Description

      MariaDB has SHOW EXPLAIN, and MySQL 5.7 got EXPLAIN FOR CONNECTION.
      We should support EXPLAIN FOR CONNECTION syntax for compatibility purposes.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28125 Server crashes in Explain_table_access::tag_to_json upon SHOW EXPLAIN FORMAT=JSON

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-28112 prepare 10.9.0 preview releases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-27021 Extend SHOW EXPLAIN to support SHOW ANALYZE [FORMAT=JSON]

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-27776 Make EXPLAIN show filtered and partitions columns

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Priority Major [ 3 ] Minor [ 4 ]
            greenman Ian Gilfillan made changes -
            Labels Compatibility
            psergei Sergei Petrunia made changes -
            Labels Compatibility Compatibility optimizer
            psergei Sergei Petrunia made changes -
            Assignee Sergei Krivonos [ JIRAUSER49805 ]
            psergei Sergei Petrunia made changes -
            Fix Version/s 10.7.1 [ 26120 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.7.1 [ 26120 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.7 [ 24805 ]
            sergei.krivonos Sergei Krivonos (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Summary 10.2: Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN Add EXPLAIN FOR CONNECTION syntax support to SHOW EXPLAIN
            sergei.krivonos Sergei Krivonos (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            psergei Sergei Petrunia made changes -
            sergei.krivonos Sergei Krivonos (Inactive) made changes -
            Rank Ranked higher
            psergei Sergei Petrunia made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 75476 ] MariaDB v4 [ 131659 ]
            psergei Sergei Petrunia made changes -
            Assignee Sergei Krivonos [ JIRAUSER49805 ]
            oleg.smirnov Oleg Smirnov made changes -
            Assignee Oleg Smirnov [ JIRAUSER50405 ]
            oleg.smirnov Oleg Smirnov made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.8 [ 26121 ]
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            psergei Sergei Petrunia made changes -
            Assignee Oleg Smirnov [ JIRAUSER50405 ]
            serg Sergei Golubchik made changes -
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ]
            elenst Elena Stepanova made changes -
            alice Alice Sherepa made changes -
            Assignee Elena Stepanova [ elenst ] Alice Sherepa [ alice ]
            alice Alice Sherepa made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            psergei Sergei Petrunia made changes -
            Fix Version/s 10.9.1 [ 27114 ]
            Fix Version/s 10.9 [ 26905 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility optimizer Compatibility Preview_10.9 optimizer

            People

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