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

Suddenly Queryplan skip LEFT JOINS and fail to retrieve full results on certain dataset

    XMLWordPrintable

Details

    Description

      Since 10.3.29-1, MariaDb is not able to complete correctly LEFT JOIN in SUBQUERY that have multiple ON clause columns coming from different tables.

      The only way to make it works is to substitute all INNER JOIN with the "STRAIGHT_JOIN" on all tables that have the columns needed by "ON clause" of the LEFT JOIN , this will fix results but on large datasets will take likely 30 - 40 seconds instead of few microseconds.

      So the only way it works back again is to downgrade to 10.3.28.

      I have to said that this is really disappointing: this is likely the 3rd critical bug in less than 1 year.
      APPs suddenly stop to works and it tooks hours to understand that the issue is not the query itself but instead the latest MariaDb's update.
      This is becoming really too much frequent.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              maxcuttins Massimiliano Cuttini
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.