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

LP:670417 - Diverging results in maria-5.3-mwl128-dsmrr-cpk with join buffer (incremental, BKA join)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      The following query

      SELECT table2.col_varchar_key FROM t2 STRAIGHT_JOIN ( t1 AS table2 JOIN t1 AS table3 ON table3.pk ) ON table3.col_varchar_key = table2.col_varchar_key AND table3.col_varchar_key = table2.col_varchar_nokey ;

      Returns 999 rows when executed with BKA in maria-5.3-mwl128-dsmrr-cpk . All other execution plans and trees (maria-5.3 and maria-5.3-mwl128) agree that the query should return 1000 rows.

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.