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

regression? Join using derived with aggregation returns incorrect results

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.6.5, 10.4(EOL), 10.5, 10.6, 10.7(EOL)
    • N/A
    • Data Manipulation - Subquery
    • None
    • openSUSE Leap

    Description

      We see the same error as described (and fixed for some versions <= 10.5.x) in MDEV-25714 on MariaDB 10.6.5.

      Test case and description was already included in MDEV-25714 but I don't know if a new issue is required, or I should have re-opened that issue, or create this new issue...

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27510 Query returns wrong result when using split optimization

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25714 Join using derived with aggregation returns incorrect results

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

          Activity

            Ascending order - Click to sort in descending order
            alice Alice Sherepa added a comment -

            Thanks!
            I repeated the bug with the test case, that was provided in MDEV-25714 by Daniel Howard,
            it is fixed by the commit 00412656719bba by Igor Bababev (https://github.com/MariaDB/server/commit/00412656719bba79cf9a350db05065b0b7007680), MDEV-27510, will be included in the next release

            alice Alice Sherepa added a comment - Thanks! I repeated the bug with the test case, that was provided in MDEV-25714 by Daniel Howard, it is fixed by the commit 00412656719bba by Igor Bababev ( https://github.com/MariaDB/server/commit/00412656719bba79cf9a350db05065b0b7007680 ), MDEV-27510 , will be included in the next release
            jmozdzen Jens-U. Mozdzen added a comment -

            Thank you for the confirmation.

            (In case you have automated release tests, you might want to consider including Daniels steps Reading through various tickets it appears that this problem reared its ugly head for more than one version.)

            jmozdzen Jens-U. Mozdzen added a comment - Thank you for the confirmation. (In case you have automated release tests, you might want to consider including Daniels steps Reading through various tickets it appears that this problem reared its ugly head for more than one version.)

            People

              alice Alice Sherepa
              jmozdzen Jens-U. Mozdzen
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.