diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2020-06-25 18:51:45 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2020-07-04 01:44:47 +0200 |
| commit | 4227dd2ac6659cf65e2fc583ae6060e301cd673c (patch) | |
| tree | 297fa8a738505637f29604bc62b5f59177a489d0 /mysql-test/main/temp_table.result | |
| parent | 6c52931680a4a24da04d7de7b74321d9ff507745 (diff) | |
| download | mariadb-git-4227dd2ac6659cf65e2fc583ae6060e301cd673c.tar.gz | |
continue DROP TEMPORARY TABLE t1, t2, t3 after error.
normal DROP TABLE with many tables continues after an error,
trying to drop as many tables as possible. But DROP TEMPORARY TABLE
was aborting on the first error. Change it to behave as DROP TABLE does.
Diffstat (limited to 'mysql-test/main/temp_table.result')
| -rw-r--r-- | mysql-test/main/temp_table.result | 21 |
1 files changed, 19 insertions, 2 deletions
diff --git a/mysql-test/main/temp_table.result b/mysql-test/main/temp_table.result index 293b6d5cd77..64a5d9b681b 100644 --- a/mysql-test/main/temp_table.result +++ b/mysql-test/main/temp_table.result @@ -1,5 +1,3 @@ -drop table if exists t1,t2; -drop view if exists v1; # # test basic creation of temporary tables together with normal table # @@ -602,3 +600,22 @@ DROP TEMPORARY TABLE t1; # # End of 10.2 tests # +create function f1() returns int +begin +drop temporary table t1, t2; +return 1; +end; +$$ +create temporary table t1 (a int); +create temporary table t2 (a int); +insert t1 values (2); +insert t2 values (3); +select a,f1() from t1; +ERROR HY000: Can't reopen table: 't1' +drop function f1; +drop temporary table t1; +drop temporary table t2; +ERROR 42S02: Unknown table 'test.t2' +# +# End of 10.5 tests +# |