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
          Matthieu Lombard
        2. screenshot-1.png
          13 kB
          Matthieu Lombard
        3. screenshot-2.png
          65 kB
          Matthieu Lombard
        4. screenshot-3.png
          9 kB
          Matthieu Lombard
        5. screenshot-4.png
          56 kB
          Matthieu Lombard

        Issue Links

          Activity

            People

              alice Alice Sherepa
              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.