diff options
Diffstat (limited to 'mysql-test/suite/perfschema/t/table_name.test')
| -rw-r--r-- | mysql-test/suite/perfschema/t/table_name.test | 33 |
1 files changed, 22 insertions, 11 deletions
diff --git a/mysql-test/suite/perfschema/t/table_name.test b/mysql-test/suite/perfschema/t/table_name.test index 5fb8ccd0f7f..e80185e8b87 100644 --- a/mysql-test/suite/perfschema/t/table_name.test +++ b/mysql-test/suite/perfschema/t/table_name.test @@ -34,7 +34,8 @@ INSERT INTO `sql_1` VALUES(1,'one'); --sorted_result SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # Drop the tables, verify that the table objects are removed. --echo @@ -43,7 +44,8 @@ DROP TABLE `sql_1`; --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # @@ -59,7 +61,8 @@ INSERT INTO sql_temp2_innodb VALUES(1,'one'); --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # Drop the tables, verify that the table objects are not created. --echo @@ -68,7 +71,8 @@ DROP TABLE sql_temp2_innodb; --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # @@ -86,7 +90,8 @@ INSERT INTO `#sql_temp3_innodb` VALUES(1,'one'); --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # Drop the temporary tables. --echo @@ -97,7 +102,8 @@ DROP TABLE `#sql_temp3_innodb`; --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # @@ -114,7 +120,8 @@ INSERT INTO `#sql_temp4_myisam` VALUES(1,'one'); --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # Truncate the MyISAM temporary tables, forcing them to be recreated as non-temporary. --echo @@ -125,7 +132,8 @@ TRUNCATE TABLE `#sql_temp4_myisam`; --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # Drop the recreated MyISAM tables; --echo @@ -136,7 +144,8 @@ DROP TABLE `#sql_temp4_myisam`; --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # @@ -152,7 +161,8 @@ ALTER TABLE t1 ADD COLUMN (b int); --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; --echo --echo # Drop the MyISAM table --echo @@ -163,4 +173,5 @@ DROP TABLE t1; --echo SELECT object_type, object_schema, object_name FROM performance_schema.objects_summary_global_by_type -WHERE object_schema="test"; +WHERE object_schema="test" +ORDER BY object_name; |