diff options
| author | unknown <sergefp@mysql.com> | 2005-04-25 04:00:35 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-04-25 04:00:35 +0400 |
| commit | 85ef43b4d09ca3899f379868dfbc414e84fc700b (patch) | |
| tree | ea2edb12bc40c578cf90553fc2f9b48b0c52a811 /mysql-test/t/temp_table.test | |
| parent | c3e4d6a291183988ba68e38c4fceb5e1e3986dbc (diff) | |
| download | mariadb-git-85ef43b4d09ca3899f379868dfbc414e84fc700b.tar.gz | |
Fix for BUG#8921: Make SHOW CREATE VIEW ignore temporary tables.
mysql-test/r/temp_table.result:
Testcase for BUG#8921
mysql-test/t/temp_table.test:
Testcase for BUG#8921
Diffstat (limited to 'mysql-test/t/temp_table.test')
| -rw-r--r-- | mysql-test/t/temp_table.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/temp_table.test b/mysql-test/t/temp_table.test index 74276c7668c..eeb33515570 100644 --- a/mysql-test/t/temp_table.test +++ b/mysql-test/t/temp_table.test @@ -89,3 +89,18 @@ flush status; select * from t1 group by d; show status like "created_tmp%tables"; drop table t1; + +# Fix for BUG#8921: Check that temporary table is ingored by view commands. +create temporary table t1 as select 'This is temp. table' A; +create view t1 as select 'This is view' A; +select * from t1; +show create table t1; +show create view t1; +drop view t1; +select * from t1; +create view t1 as select 'This is view again' A; +select * from t1; +drop table t1; +select * from t1; +drop view t1; + |