Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1743

LP #1625151: InnoDB index dives do not detect concurrent tree changes, return bogus estimates

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 27-01-2017 07:52:04

      On PS 5.6 trunk:

      main.index_merge_innodb w2 [ fail ]
      Test ended at 2016-09-03 08:59:05

      CURRENT_TEST: main.index_merge_innodb
      — /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/ubuntu-precise-32bit/mysql-test/r/index_merge_innodb.result 2016-09-03 15:11:32.349924000 +0300
      +++ /mnt/workspace/percona-server-5.6-trunk/BUILD_TYPE/release/Host/ubuntu-precise-32bit/build/mysql-test/var/2/log/index_merge_innodb.reject 2016-09-03 15:59:05.217924000 +0300
      @@ -1134,7 +1134,7 @@
      update t1 set key2=key1,key3=key1;
      explain select * from t1 where (key3 > 30 and key3<35) or (key2 >32 and key2 < 40);
      id select_type table type possible_keys key key_len ref rows Extra
      -1 SIMPLE t1 index_merge i2,i3 i3,i2 4,4 NULL # Using sort_union(i3,i2); Using where
      +1 SIMPLE t1 ALL i2,i3 NULL NULL NULL # Using where
      select * from t1 where (key3 > 30 and key3<35) or (key2 >32 and key2 < 40);
      key1 key2 key3
      31 31 31

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: