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

innodb_prefix_index_cluster_optimization hits debug build assert on UTF-8 columns

Details

    • 10.1.32

    Description

      ./mtr --do-test=ctype --mysqld=--innodb_prefix_index_cluster_optimization=ON
      		 
      ...
      		 
      2017-03-14 14:48:08 700001c51000  InnoDB: Assertion failure in thread 123145332002816 in file row0sel.cc line 2717
      		 
      InnoDB: Failing assertion: len * templ->mbmaxlen >= templ->mysql_col_len || (field_no == templ->icp_rec_field_no && field->prefix_len > 0)
      		 
      ...
      		 
      Failing test(s): main.ctype_utf8 main.ctype_utf8mb4 main.ctype_utf8mb4_innodb

      This is a parallel bug to https://github.com/facebook/mysql-5.6/issues/568, but appears to be less serious, as Facebook patch silently returns wrong query results too, whereas MariaDB only crashes the debug build. I don't know if these testcases return correct results in the release build.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23600 SIGFPE in row_search_with_covering_prefix

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-6929 Port Facebook Prefix Index Queries Optimization

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12486 Incorrect results with prefix_index_cluster_optimization enabled

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25440 Assertion `cmp_rec_rec(rec, old_rec, offsets, old_offsets, m_index) > 0' failed in PageBulk::insert

          • Major - Major loss of function.
          • Closed
          links to

          Web Link #568 innodb_prefix_index_cluster_optimization silently returns wrong query results for UTF-8 and other > 1 byte character sets

          Activity

            People

              thiru Thirunarayanan Balathandayuthapani
              laurynas Laurynas Biveinis
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.