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

Optimizer_switch split_materialized Returns Wrong Results

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.5.11, 10.5.12
    • Fix Version/s: 10.3, 10.4, 10.5, 10.6
    • Component/s: Optimizer
    • Labels:
      None
    • Environment:
      Centos7

      Description

      There is a bug with split_materialized.
      When optimizer_switch='split_materialized=on'; the attached query returns very wrong results. After disabling the split_materialized, it returns the correct results.

      This bug starts in 10.5.10, which is the version that includes the fixes from 10.4.19. 10.4.19 includes MDEV-25128 fix which could be a blame option. The bug does not happen in 10.5.9.

      I've attached the .sql to reproduce the bug.

        Attachments

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            ksizemore Kathryn Sizemore
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration