Debian Codegraph @

mysql-test/suite/perfschema/r/table_name.result

raw
1
2 #
3 # TEST 1: Temporary tables, no special prefix.
4 #
5
6 CREATE TEMPORARY TABLE sql_temp2_innodb (a int, b text) ENGINE=INNODB;
7 INSERT INTO sql_temp2_innodb VALUES(1,'one');
8
9 # Confirm that the temporary tables are ignored.
10
11 SELECT object_type, object_schema, object_name
12 FROM performance_schema.objects_summary_global_by_type
13 WHERE object_schema="test"
14 ORDER BY object_name;
15 object_type object_schema object_name
16
17 # Drop the tables, verify that the table objects are not created.
18
19 DROP TABLE sql_temp2_innodb;
20
21 SELECT object_type, object_schema, object_name
22 FROM performance_schema.objects_summary_global_by_type
23 WHERE object_schema="test"
24 ORDER BY object_name;
25 object_type object_schema object_name
26
27 #
28 # TEST 2: Temporary tables with the "#sql" prefix.
29 #
30
31 CREATE TEMPORARY TABLE `#sql_temp3_innodb` (a int, b text) ENGINE=INNODB;
32 CHECK TABLE `#sql_temp3_innodb`;
33 Table Op Msg_type Msg_text
34 test.#sql_temp3_innodb check status OK
35 INSERT INTO `#sql_temp3_innodb` VALUES(1,'one');
36
37 # Confirm that the temporary tables are ignored.
38
39 SELECT object_type, object_schema, object_name
40 FROM performance_schema.objects_summary_global_by_type
41 WHERE object_schema="test"
42 ORDER BY object_name;
43 object_type object_schema object_name
44
45 # Drop the temporary tables.
46
47 DROP TABLE `#sql_temp3_innodb`;
48
49 # Confirm that the temporary tables are still ignored.
50
51 SELECT object_type, object_schema, object_name
52 FROM performance_schema.objects_summary_global_by_type
53 WHERE object_schema="test"
54 ORDER BY object_name;
55 object_type object_schema object_name
56
57 # Confirm that no tables remain;
58
59 SELECT object_type, object_schema, object_name
60 FROM performance_schema.objects_summary_global_by_type
61 WHERE object_schema="test"
62 ORDER BY object_name;
63 object_type object_schema object_name