Debian Codegraph @

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

raw
1 create database explain_test_db;
2 use explain_test_db;
3 create table explain_test_table(c int);
4 create procedure explain_test_proc()
5 BEGIN
6 select * from explain_test_table;
7 END //
8 call explain_test_proc();
9 c
10 insert into performance_schema.setup_objects values ('PROCEDURE',
11 'explain_test_db', 'explain_test_proc', 'YES', 'YES');
12
13 ====================================================================
14 Testing index for columns OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
15 ====================================================================
16 ############ Explain for Query ####################################
17 explain select ENABLED
18 from performance_schema.setup_objects
19 where OBJECT_TYPE = "impossible";
20 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
21 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 1 const # 100.00 Using where
22 ############ Explain for Query ####################################
23 explain select ENABLED
24 from performance_schema.setup_objects
25 where OBJECT_TYPE > "impossible";
26 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
27 1 SIMPLE setup_objects NULL ALL OBJECT NULL NULL NULL # 33.33 Using where
28 ############ Explain for Query ####################################
29 explain select ENABLED
30 from performance_schema.setup_objects
31 where OBJECT_TYPE < "2";
32 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
33 1 SIMPLE setup_objects NULL ALL OBJECT NULL NULL NULL # 33.33 Using where
34 ############ Explain for Query ####################################
35 explain select ENABLED
36 from performance_schema.setup_objects
37 where OBJECT_TYPE = "PROCEDURE";
38 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
39 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 1 const # 100.00 Using where
40 ############ Explain for Query ####################################
41 explain select ENABLED
42 from performance_schema.setup_objects
43 where OBJECT_TYPE = "impossible"
44 and OBJECT_SCHEMA = "impossible";
45 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
46 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 260 const,const # 100.00 Using where
47 ############ Explain for Query ####################################
48 explain select ENABLED
49 from performance_schema.setup_objects
50 where OBJECT_TYPE = "PROCEDURE"
51 and OBJECT_SCHEMA = "impossible";
52 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
53 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 260 const,const # 100.00 Using where
54 ############ Explain for Query ####################################
55 explain select ENABLED
56 from performance_schema.setup_objects
57 where OBJECT_TYPE = "PROCEDURE"
58 and OBJECT_SCHEMA > "impossible";
59 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
60 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 1 const # 33.33 Using where
61 ############ Explain for Query ####################################
62 explain select ENABLED
63 from performance_schema.setup_objects
64 where OBJECT_TYPE = "PROCEDURE"
65 and OBJECT_SCHEMA < "2";
66 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
67 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 1 const # 33.33 Using where
68 ############ Explain for Query ####################################
69 explain select ENABLED
70 from performance_schema.setup_objects
71 where OBJECT_TYPE = "PROCEDURE"
72 and OBJECT_SCHEMA = "explain_test_db";
73 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
74 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 260 const,const # 100.00 Using where
75 ############ Explain for Query ####################################
76 explain select ENABLED
77 from performance_schema.setup_objects
78 where OBJECT_TYPE = "impossible"
79 and OBJECT_SCHEMA = "impossible"
80 and OBJECT_NAME = "impossible";
81 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
82 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
83 ############ Explain for Query ####################################
84 explain select ENABLED
85 from performance_schema.setup_objects
86 where OBJECT_TYPE = "PROCEDURE"
87 and OBJECT_SCHEMA = "explain_test_db"
88 and OBJECT_NAME = "impossible";
89 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
90 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table
91 ############ Explain for Query ####################################
92 explain select ENABLED
93 from performance_schema.setup_objects
94 where OBJECT_TYPE = "PROCEDURE"
95 and OBJECT_SCHEMA = "explain_test_db"
96 and OBJECT_NAME > "impossible";
97 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
98 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 260 const,const # 33.33 Using where
99 ############ Explain for Query ####################################
100 explain select ENABLED
101 from performance_schema.setup_objects
102 where OBJECT_TYPE = "PROCEDURE"
103 and OBJECT_SCHEMA = "explain_test_db"
104 and OBJECT_NAME < "2";
105 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
106 1 SIMPLE setup_objects NULL ref OBJECT OBJECT 260 const,const # 33.33 Using where
107 ############ Explain for Query ####################################
108 explain select ENABLED
109 from performance_schema.setup_objects
110 where OBJECT_TYPE = "PROCEDURE"
111 and OBJECT_SCHEMA = "explain_test_db"
112 and OBJECT_NAME = "explain_test_proc";
113 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
114 1 SIMPLE setup_objects NULL const OBJECT OBJECT 518 const,const,const # 100.00 NULL
115 ############# Explain End #########################################
116 flush status;
117 select ENABLED
118 from performance_schema.setup_objects
119 where OBJECT_TYPE = "PROCEDURE"
120 and OBJECT_SCHEMA = "explain_test_db"
121 and OBJECT_NAME = "explain_test_proc";
122 ENABLED
123 #
124 OK: handler_read_key incremented
125 delete from performance_schema.setup_objects where object_schema = 'explain_test_db';
126 drop table explain_test_db.explain_test_table;
127 drop database explain_test_db;