summaryrefslogtreecommitdiff
path: root/mysql-test/include/index_merge_ror_cpk.inc
diff options
context:
space:
mode:
authorMonty <monty@mariadb.org>2019-04-01 19:42:26 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2019-04-04 08:58:48 +0300
commit71a2e6a3c66bc1e84809e0e91ffaef1cadc87642 (patch)
treef6e8f63b7d40509a3a305a95e7014fbf80589f29 /mysql-test/include/index_merge_ror_cpk.inc
parent6a9b2163011938d813ebe4edf9264a0e35b1c6bf (diff)
downloadmariadb-git-71a2e6a3c66bc1e84809e0e91ffaef1cadc87642.tar.gz
index_merge_innodb did sometimes give wrong results
Fixed by adding more rows to a table Other things: - Speed up index_merge tests 20% by adding begin/commit around loops that generated rows.
Diffstat (limited to 'mysql-test/include/index_merge_ror_cpk.inc')
-rw-r--r--mysql-test/include/index_merge_ror_cpk.inc4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/include/index_merge_ror_cpk.inc b/mysql-test/include/index_merge_ror_cpk.inc
index df42745b4fc..0a307aa4fdb 100644
--- a/mysql-test/include/index_merge_ror_cpk.inc
+++ b/mysql-test/include/index_merge_ror_cpk.inc
@@ -56,14 +56,14 @@ create table t1
);
--disable_query_log
-set autocommit=0;
+begin;
let $1=10000;
while ($1)
{
eval insert into t1 values ($1 div 10,$1 mod 100, $1/100,$1/100, $1/100,$1/100,$1/100,$1/100,$1/100, $1 mod 100, $1/1000,'filler-data-$1','filler2');
dec $1;
}
-set autocommit=1;
+commit;
--enable_query_log
# Verify that range scan on CPK is ROR