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

LP:668290 - Wrong result in maria-5.3-mwl128 with join_cache_level = 4 and small join_buffer_size and join buffer (flat, BNLH join)

    XMLWordPrintable

Details

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

    Description

      The following query:

      SELECT t2 .col_int_key FROM t2 JOIN t1 ON t2 .col_varchar_10_latin1_key = t1 .col_varchar_10_utf8_key ;

      returns no rows when executed with join_cache_level = 4, join_buffer_size = 164 , even though there are rows for which the condition t2 .col_varchar_10_latin1_key = t1 .col_varchar_10_utf8_key is TRUE.

      The execution strategy is reported as "Using join buffer (flat, BNLH join)". maria-5.3 is not affected.

      Attachments

        Activity

          People

            igor Igor Babaev (Inactive)
            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.