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/r/tablelock.result | |
| 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/r/tablelock.result')
| -rw-r--r-- | mysql-test/r/tablelock.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/tablelock.result b/mysql-test/r/tablelock.result index 2ffd8f928a9..6923ad40916 100644 --- a/mysql-test/r/tablelock.result +++ b/mysql-test/r/tablelock.result @@ -46,3 +46,12 @@ CREATE TABLE t2 (a int); lock tables t1 write,t1 as b write, t2 write, t2 as c read; drop table t2,t1; unlock tables; +create temporary table t1(f1 int); +lock tables t1 write; +insert into t1 values (1); +show columns from t1; +Field Type Null Key Default Extra +f1 int(11) YES NULL +insert into t1 values(2); +drop table t1; +unlock tables; |