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

LP:933117 - Wrong use_count reported by the range optimizer

    XMLWordPrintable

Details

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

    Description

      The bug #58731 from bugs.mysql.com is reproducible in mariadb-5.2.

      When executing the following simple test case

      create table t1 (a int, b int, c int, key idx (a,c,b));
      insert into t1 values (0,0,0), (0,0,0);
      select 1 from t1 force index (idx) where a >=1 and b <= 1 and a=c and c > 1;

      the debug build of the mariadb-5.2 server reports:

      [Note] Use_count: Wrong count for key at 0x2279948, 0 should be 1.

      Attachments

        Activity

          People

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