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

Left join to derived table on multiple clauses with aggregation returns missing/incorrect results

    XMLWordPrintable

    Details

      Description

      I couldn't work out how to reopen an issue, so sorry for making a new one.

      The problem in MDEV-25714 and MDEV-21614 seems to be back in 10.6.4 (we recently upgraded from 10.5.6).

      Using `SET optimizer_switch="split_materialized=off";` fixes the problem, so this is our temporary work-around.

      Thanks for your help.

        Attachments

        1. dataset.sql
          2 kB
        2. screenshot-1.png
          screenshot-1.png
          13 kB
        3. screenshot-2.png
          screenshot-2.png
          65 kB
        4. screenshot-3.png
          screenshot-3.png
          9 kB
        5. screenshot-4.png
          screenshot-4.png
          56 kB

          Issue Links

            Activity

              People

              Assignee:
              alice Alice Sherepa
              Reporter:
              violuke Luke Cousins
              Votes:
              4 Vote for this issue
              Watchers:
              8 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.