#At file:///home/dlenev/src/bzr/mysql-trunk-rt-bg53238/ based on revid:dlenev@stripped
3025 Dmitry Lenev 2010-05-26
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.
modified:
mysql-test/r/mdl_sync.result
mysql-test/t/mdl_sync.test
=== modified file 'mysql-test/r/mdl_sync.result'
--- a/mysql-test/r/mdl_sync.result 2010-05-25 20:01:38 +0000
+++ b/mysql-test/r/mdl_sync.result 2010-05-26 19:58:16 +0000
@@ -330,9 +330,9 @@ select column_name from information_sche
table_schema='test' and table_name='t1';
column_name
c1
-select count(*) from t1;
-count(*)
-4
+# Disable result log to make test robust against
+# effects of concurrent insert.
+select * from t1;
insert into t1 values (1);
# Check that SNW lock is not compatible with SW lock.
# Again we use ALTER TABLE which fails after opening
=== modified file 'mysql-test/t/mdl_sync.test'
--- a/mysql-test/t/mdl_sync.test 2010-05-25 20:01:38 +0000
+++ b/mysql-test/t/mdl_sync.test 2010-05-26 19:58:16 +0000
@@ -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
Attachment: [text/bzr-bundle] bzr/dlenev@mysql.com-20100526195816-h4tp1c1q20dnq0nz.bundle
Thread |
---|
• bzr commit into mysql-trunk-runtime branch (dlenev:3025) Bug#53238 | Dmitry Lenev | 26 May |