diff options
| author | unknown <gluh@mysql.com/mgluh.(none)> | 2008-02-22 12:30:17 +0400 |
|---|---|---|
| committer | unknown <gluh@mysql.com/mgluh.(none)> | 2008-02-22 12:30:17 +0400 |
| commit | 1a8be8bccb198959c35794bc9055da093b0a4fc9 (patch) | |
| tree | 58153526cb62fa6d5252b0b0132435409adfa806 /mysql-test/t/tablelock.test | |
| parent | 18f885ed4c26c58d1dcb0691ee45f3adaea74dbb (diff) | |
| download | mariadb-git-1a8be8bccb198959c35794bc9055da093b0a4fc9.tar.gz | |
Bug#23588 SHOW COLUMNS on a temporary table causes locking issues
skip lock_type update for temporary tables
mysql-test/r/tablelock.result:
test result
mysql-test/t/tablelock.test:
test case
sql/sql_base.cc:
skip lock_type update for temporary tables
Diffstat (limited to 'mysql-test/t/tablelock.test')
| -rw-r--r-- | mysql-test/t/tablelock.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/tablelock.test b/mysql-test/t/tablelock.test index 95533903b45..5ac93f09ac1 100644 --- a/mysql-test/t/tablelock.test +++ b/mysql-test/t/tablelock.test @@ -49,3 +49,16 @@ drop table t2,t1; unlock tables; # End of 4.1 tests + +# +# Bug#23588 SHOW COLUMNS on a temporary table causes locking issues +# +create temporary table t1(f1 int); +lock tables t1 write; +insert into t1 values (1); +show columns from t1; +insert into t1 values(2); +drop table t1; +unlock tables; + +# End of 5.0 tests |