diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2015-06-19 20:58:26 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2015-06-27 09:40:56 +0200 |
| commit | 1ce71c847804c08c23435193763a1aa5cfa51861 (patch) | |
| tree | e3fde781344d62c8ebe7478e691fcda17999ee3b /mysql-test/t/temp_table.test | |
| parent | e24caa758890e0a753c0be9293a09f5d2931e377 (diff) | |
| download | mariadb-git-1ce71c847804c08c23435193763a1aa5cfa51861.tar.gz | |
MDEV-7832 Add status variables to track CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE
Pretend that CREATE TABLE and CREATE TEMPORARY TABLE are
two different commands internally. The user doesn't need
to know that they both are SQLCOM_CREATE_TABLE.
Same for DROP [TEMPORARY] TABLE
Diffstat (limited to 'mysql-test/t/temp_table.test')
| -rw-r--r-- | mysql-test/t/temp_table.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/temp_table.test b/mysql-test/t/temp_table.test index 542a3487196..987fbf7e848 100644 --- a/mysql-test/t/temp_table.test +++ b/mysql-test/t/temp_table.test @@ -325,3 +325,16 @@ DROP TABLES t1, t2, t3; # --error ER_PARSE_ERROR create temporary temporary table t1 (a int); + +# +# MDEV-7832 Add status variables to track CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE +# +flush status; +create table t1 (a int); +create temporary table t2 (a int); +create temporary table t3 (a int); +drop table t1; +drop table t2; +drop temporary table t3; +show status like 'com_create%table'; +show status like 'com_drop%table'; |