From 1ce71c847804c08c23435193763a1aa5cfa51861 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Fri, 19 Jun 2015 20:58:26 +0200 Subject: 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 --- mysql-test/t/temp_table.test | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'mysql-test/t/temp_table.test') 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'; -- cgit v1.2.1