diff options
| author | Anel Husakovic <anel@mariadb.org> | 2022-07-16 13:32:37 +0200 |
|---|---|---|
| committer | Anel Husakovic <anel@mariadb.org> | 2022-07-16 13:32:37 +0200 |
| commit | 243f33bc25ac50b298bc5f5c8ae15c6facc2d70d (patch) | |
| tree | e8427daa74d82ec39ed04bb561a20ecb53d502dc /mysql-test/main | |
| parent | 18bb37d7e5b9b723729f59659a4d5a7ee2b7d97c (diff) | |
| download | mariadb-git-243f33bc25ac50b298bc5f5c8ae15c6facc2d70d.tar.gz | |
MDEV-28332: Alter on temporary table causes ER_TABLE_EXISTS_ERROR note
- Additionally update comments
Reviewed by: <monty@mariadb.org>
Diffstat (limited to 'mysql-test/main')
| -rw-r--r-- | mysql-test/main/information_schema_temp_table.result | 12 | ||||
| -rw-r--r-- | mysql-test/main/information_schema_temp_table.test | 11 | ||||
| -rw-r--r-- | mysql-test/main/lock_multi.result | 2 | ||||
| -rw-r--r-- | mysql-test/main/temp_table.result | 2 |
4 files changed, 23 insertions, 4 deletions
diff --git a/mysql-test/main/information_schema_temp_table.result b/mysql-test/main/information_schema_temp_table.result index e85def6bfd2..ab2cd811ba2 100644 --- a/mysql-test/main/information_schema_temp_table.result +++ b/mysql-test/main/information_schema_temp_table.result @@ -96,3 +96,15 @@ drop table test.t_temp; drop table test.t_temp; drop database my_db; drop database some_db; +# +# MDEV-28332: Alter on temporary table causes ER_TABLE_EXISTS_ERROR note +# +create table t (a int); +create temporary table t (b int); +Warnings: +Level Note +Code 1050 +Message Table 't' already exists +alter table t add c int; +drop temporary table t; +drop table t; diff --git a/mysql-test/main/information_schema_temp_table.test b/mysql-test/main/information_schema_temp_table.test index 7a34324f919..4257a5dd7d6 100644 --- a/mysql-test/main/information_schema_temp_table.test +++ b/mysql-test/main/information_schema_temp_table.test @@ -92,3 +92,14 @@ drop database some_db; # Wait till all disconnects are completed --source include/wait_until_count_sessions.inc + +--echo # +--echo # MDEV-28332: Alter on temporary table causes ER_TABLE_EXISTS_ERROR note +--echo # +create table t (a int); +create temporary table t (b int); +alter table t add c int; + +# Cleanup +drop temporary table t; +drop table t; diff --git a/mysql-test/main/lock_multi.result b/mysql-test/main/lock_multi.result index 6d0a1807d6e..83e20bc5e33 100644 --- a/mysql-test/main/lock_multi.result +++ b/mysql-test/main/lock_multi.result @@ -611,8 +611,6 @@ CREATE TEMPORARY TABLE t1 (id INT); Warnings: Note 1050 Table 't1' already exists ALTER TABLE t1 ADD COLUMN j INT; -Warnings: -Note 1050 Table 't1' already exists connection default; disconnect con1; UNLOCK TABLES; diff --git a/mysql-test/main/temp_table.result b/mysql-test/main/temp_table.result index 97ef065dcc6..ff8156f9ace 100644 --- a/mysql-test/main/temp_table.result +++ b/mysql-test/main/temp_table.result @@ -60,8 +60,6 @@ a b 5 f 6 g alter table t2 add primary key (a,b); -Warnings: -Note 1050 Table 't2' already exists drop table t1,t2; select * from t1; c d |