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

Wrong EXPLAIN or ANALYZE output: SUBQUERY instead of DEPENDENT SUBQUERY

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.2(EOL)
    • 11.2(EOL)
    • Optimizer
    • None

    Description

      This is coming from MDEV-25008.

      The testcase is here:
      https://jira.mariadb.org/browse/MDEV-25008?focusedCommentId=181152&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-181152 ("Alice's testcase")

      The complaint is here:

      https://jira.mariadb.org/browse/MDEV-25008?focusedCommentId=291378&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-291378

      What is displayed as SUBQUERY seems to be executed as dependent subquery.

      (check the minimum affected version. old versions like 10.5 do not seem to be affected. 11.2 is affected)

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-25008 Single-table UPDATE/DELETE: make cost-based choice between subquery strategies

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

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            psergei Sergei Petrunia made changes -
            Fix Version/s 11.2 [ 28603 ]
            psergei Sergei Petrunia made changes -
            Description This is coming from MDEV-25008.

            The testcase is here:
            https://jira.mariadb.org/browse/MDEV-25008?focusedCommentId=181152&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-181152 ("Alice's testcase")

            The complaint is here:

            https://jira.mariadb.org/browse/MDEV-25008?focusedCommentId=291378&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-291378

            What is displayed as SUBQUERY seems to be executed as dependent subquery.             		This is coming from MDEV-25008.

            The testcase is here:
            https://jira.mariadb.org/browse/MDEV-25008?focusedCommentId=181152&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-181152 ("Alice's testcase")

            The complaint is here:

            https://jira.mariadb.org/browse/MDEV-25008?focusedCommentId=291378&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-291378

            What is displayed as SUBQUERY seems to be executed as dependent subquery.

            (check the minimum affected version. old versions like 10.5 do not seem to be affected. 11.2 is affected)

            People

              Unassigned Unassigned
              psergei Sergei Petrunia
              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.