diff options
| author | unknown <pem@mysql.com> | 2003-02-28 15:07:14 +0100 |
|---|---|---|
| committer | unknown <pem@mysql.com> | 2003-02-28 15:07:14 +0100 |
| commit | 1ff79b61a056e5b50fc0402680f6f74ca1eb2a57 (patch) | |
| tree | 1e6844a1e5ea3c286461cf1aedc892b978b5d9fc /mysql-test | |
| parent | aecc6a21bd1e802d31318cf3e82d03d57b090c5f (diff) | |
| download | mariadb-git-1ff79b61a056e5b50fc0402680f6f74ca1eb2a57.tar.gz | |
Closing tables during SP execution the proper way.
mysql-test/r/show_check.result:
proc table now shows up in different places.
mysql-test/r/status.result:
proc table now shows up in different places.
sql/sp.cc:
Fixed closing of tables.
sql/sp_head.cc:
Close tables after each sub statement.
sql/sql_class.cc:
Removed closing of tables in various send_eof() methods again.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/show_check.result | 1 | ||||
| -rw-r--r-- | mysql-test/r/status.result | 2 |
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; |