diff options
| author | unknown <dlenev@mockturtle.local> | 2006-09-29 19:39:15 +0400 |
|---|---|---|
| committer | unknown <dlenev@mockturtle.local> | 2006-09-29 19:39:15 +0400 |
| commit | 35f7ae16bf070ce2f3faee6c9a101b8ca3bacb42 (patch) | |
| tree | d66a4897da6f676c9e41bd1dd12ec7c0f690fd67 /mysql-test/r/temp_table.result | |
| parent | a4dda37f6623b17b085c9ae9d7625826467d84d5 (diff) | |
| parent | d4553e35586398a89b005bff0d55280ce237483e (diff) | |
| download | mariadb-git-35f7ae16bf070ce2f3faee6c9a101b8ca3bacb42.tar.gz | |
Merge mockturtle.local:/home/dlenev/src/mysql-5.0-rt-merge
into mockturtle.local:/home/dlenev/src/mysql-5.1-rt-merge
BitKeeper/etc/collapsed:
auto-union
mysql-test/mysql-test-run.pl:
Auto merged
sql/mysql_priv.h:
Auto merged
sql/sp.cc:
Auto merged
sql/sql_acl.cc:
Auto merged
mysql-test/r/sp.result:
Manual merge.
mysql-test/r/temp_table.result:
Manual merge.
mysql-test/t/sp.test:
Manual merge.
mysql-test/t/temp_table.test:
Manual merge.
sql/sql_select.cc:
Manual merge.
sql/sql_table.cc:
Manual merge.
Diffstat (limited to 'mysql-test/r/temp_table.result')
| -rw-r--r-- | mysql-test/r/temp_table.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/temp_table.result b/mysql-test/r/temp_table.result index 637f74a1d50..6c9a389c1f4 100644 --- a/mysql-test/r/temp_table.result +++ b/mysql-test/r/temp_table.result @@ -135,6 +135,23 @@ d c bar 2 foo 1 drop table t1, t2; +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 (i INT); +LOCK TABLE t1 WRITE; +CREATE TEMPORARY TABLE t1 (i INT); +The following command should not block +DROP TEMPORARY TABLE t1; +DROP TABLE t1; +CREATE TABLE t1 (i INT); +CREATE TEMPORARY TABLE t2 (i INT); +DROP TEMPORARY TABLE t2, t1; +ERROR 42S02: Unknown table 't1' +SELECT * FROM t2; +ERROR 42S02: Table 'test.t2' doesn't exist +SELECT * FROM t1; +i +DROP TABLE t1; +End of 4.1 tests. create temporary table t1 (a int); insert into t1 values (4711); select * from t1; |