summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorpem@mysql.com <>2003-02-28 15:07:14 +0100
committerpem@mysql.com <>2003-02-28 15:07:14 +0100
commitb6ab762dc15a3ac4aa2528f9c9b2ba3725afe710 (patch)
tree1e6844a1e5ea3c286461cf1aedc892b978b5d9fc /mysql-test/r
parent16cff7e75d2c9895772554894c4e4ff5722664ae (diff)
downloadmariadb-git-b6ab762dc15a3ac4aa2528f9c9b2ba3725afe710.tar.gz
Closing tables during SP execution the proper way.
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/show_check.result1
-rw-r--r--mysql-test/r/status.result2
2 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result
index de652b05154..c5e7ca154df 100644
--- a/mysql-test/r/show_check.result
+++ b/mysql-test/r/show_check.result
@@ -127,6 +127,7 @@ insert into t1 values (1);
show open tables;
Database Table In_use Name_locked
test t1 0 0
+mysql proc 0 0
drop table t1;
create table t1 (a int not null, b VARCHAR(10), INDEX (b) ) AVG_ROW_LENGTH=10 CHECKSUM=1 COMMENT="test" TYPE=MYISAM MIN_ROWS=10 MAX_ROWS=100 PACK_KEYS=1 DELAY_KEY_WRITE=1 ROW_FORMAT=fixed;
show create table t1;
diff --git a/mysql-test/r/status.result b/mysql-test/r/status.result
index 3ef6cec32b3..f93147d00c5 100644
--- a/mysql-test/r/status.result
+++ b/mysql-test/r/status.result
@@ -14,6 +14,6 @@ update t1 set n = 3;
unlock tables;
show status like 'Table_lock%';
Variable_name Value
-Table_locks_immediate 3
+Table_locks_immediate 4
Table_locks_waited 1
drop table t1;