diff options
author | Sergei Golubchik <serg@mariadb.org> | 2019-06-16 14:53:17 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2019-06-17 12:26:26 +0200 |
commit | 20bb4ed15e6d4fa93575e6646b9c7c781346b7a8 (patch) | |
tree | 4af6e1ee3ad31ee201d8aba30ade6023a2322c99 /mysql-test/suite/heap/heap.test | |
parent | 13e8f728ec83133b990ed21404cbac1d8a0bc74c (diff) | |
download | mariadb-git-20bb4ed15e6d4fa93575e6646b9c7c781346b7a8.tar.gz |
make the heap.heap test portable
in HEAP btree indexes, the address of a record in memory is part of the
key. So, when inserting many identical keys, the actual btree
shape is defined by how and where records in memory are allocated.
records_in_range uses floats to estimate the size of the chunk of the
btree between min and max records, it depends on the btree shape and,
thus, is not portable either. As are optimizer decisions that are based
on records_in_range estimations, if the number happens to be close
to a tipping point.
as a fix, reduce the number of matching rows, so that even with
system-specific variations the optimizer would still pick the
expected plan.
Fixes heap.heap failure (range vs ALL) on ppc64
Diffstat (limited to 'mysql-test/suite/heap/heap.test')
-rw-r--r-- | mysql-test/suite/heap/heap.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/suite/heap/heap.test b/mysql-test/suite/heap/heap.test index ea07d020e4d..237685a6423 100644 --- a/mysql-test/suite/heap/heap.test +++ b/mysql-test/suite/heap/heap.test @@ -337,6 +337,7 @@ while ($1) } dec $1; } +delete from t1 where v like 'a%' and length(v) > 7; commit; --enable_query_log select count(*) from t1; |