summaryrefslogtreecommitdiff
path: root/mysql-test/t/mdl_sync.test
diff options
context:
space:
mode:
authorDmitry Lenev <dlenev@mysql.com>2010-05-26 23:58:16 +0400
committerDmitry Lenev <dlenev@mysql.com>2010-05-26 23:58:16 +0400
commit2397d7fe1938cca45f96dd5bf73a343ea0fcacf7 (patch)
tree983cf7d53e1805853bc5ab9cbc7589984b96e39b /mysql-test/t/mdl_sync.test
parentae1ae4bd63e29006cc33d44a78cf01631928aaee (diff)
downloadmariadb-git-2397d7fe1938cca45f96dd5bf73a343ea0fcacf7.tar.gz
Fix for bug #53238 "mdl_sync fails sporadically".
The problem was that mdl_sync.test was failing sporadically, due to fact that part of the test didn't take into account effects of MyISAM's concurrent insert. This patch solves the problem by making test case robust against concurrent insert.
Diffstat (limited to 'mysql-test/t/mdl_sync.test')
-rw-r--r--mysql-test/t/mdl_sync.test6
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/t/mdl_sync.test b/mysql-test/t/mdl_sync.test
index a5b631058c5..1f622b34edf 100644
--- a/mysql-test/t/mdl_sync.test
+++ b/mysql-test/t/mdl_sync.test
@@ -462,7 +462,11 @@ handler t1 open;
handler t1 close;
select column_name from information_schema.columns where
table_schema='test' and table_name='t1';
-select count(*) from t1;
+--echo # Disable result log to make test robust against
+--echo # effects of concurrent insert.
+--disable_result_log
+select * from t1;
+--enable_result_log
insert into t1 values (1);
--echo # Check that SNW lock is not compatible with SW lock.
--echo # Again we use ALTER TABLE which fails after opening