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

optimizer change for inner join vs left join

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None
    • MariaDB 10.6.5
      Galera 25.4.9

    Description

      Hi team,

      we updated to MariaDB 10.6.5 and noticed that the query plan have change between inner join and left join. The performance seems to have drop drastically for inner join.

      This is before MariaDB 10.6.5

      This is after updating to MariaDB 10.6.5

      Is this some where presented in the changelog?

      Attachments

        Activity

          People

            Unassigned Unassigned
            khaiping.loh Khai Ping
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.