summaryrefslogtreecommitdiff
path: root/mysql-test/t/status.test
diff options
context:
space:
mode:
authortsmith@ramayana.hindu.god <>2007-08-18 02:28:08 -0600
committertsmith@ramayana.hindu.god <>2007-08-18 02:28:08 -0600
commit76d173fa9df9384c40f4ef368977aeac6381c7b7 (patch)
tree1ca8add50658a1e53706c307897f1e981e51ec01 /mysql-test/t/status.test
parent2ccc36363428cfe3ef6e45e7e321cdbdac9ff33e (diff)
downloadmariadb-git-76d173fa9df9384c40f4ef368977aeac6381c7b7.tar.gz
Bug #29307: status.test fails with different Table_locks_immediate
Finish premature patch which was accidentally pushed; remove debugging info and correct the test.
Diffstat (limited to 'mysql-test/t/status.test')
-rw-r--r--mysql-test/t/status.test12
1 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/t/status.test b/mysql-test/t/status.test
index 6320f5fb143..cade1d06e38 100644
--- a/mysql-test/t/status.test
+++ b/mysql-test/t/status.test
@@ -49,18 +49,20 @@ update t1 set n = 3;
connection con2;
# wait for the other query to start executing
let $wait_condition= select 1 from INFORMATION_SCHEMA.PROCESSLIST where ID = $ID and STATE = "Locked";
-# ++Immediate = 15 + $wait_condition_reps (wait_condition.inc does one select
-# in addition to the wait condition)
+# Immediate = 14 + $wait_condition_reps ($wait_timeout is 0, so no extra select
+# is done inside wait_condition.inc)
--source include/wait_condition.inc
-# ++Immediate = 16 + $wait_condition_reps
+# ++Immediate = 15 + $wait_condition_reps
unlock tables;
connection con1;
reap;
-# ++Immediate = 17 + $wait_condition_reps
+# ++Immediate = 16 + $wait_condition_reps
show status like 'Table_locks_waited';
-# ++Immediate = 18 + $wait_condition_reps
+# ++Immediate = 17 + $wait_condition_reps
+--disable_query_log
eval select variable_value - $wait_condition_reps as Immediate from information_schema.session_status where variable_name like 'Table_locks_immediate';
+--enable_query_log
drop table t1;
disconnect con2;