Debian Codegraph @

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

raw
1 drop table if exists test.setup_objects;
2 update performance_schema.setup_instruments set enabled='NO';
3 update performance_schema.setup_instruments set enabled='YES', timed='YES'
4 where name in ('wait/io/table/sql/handler', 'wait/lock/table/sql/handler');
5 truncate table performance_schema.events_waits_history_long;
6 create table test.setup_objects as select * from performance_schema.setup_objects;
7 truncate table performance_schema.setup_objects;
8 insert into performance_schema.setup_objects
9 values ('TABLE', 'db1', 't1', 'YES', 'YES');
10 insert into performance_schema.setup_objects
11 values ('TABLE', 'db1', 't2', 'YES', 'NO');
12 insert into performance_schema.setup_objects
13 values ('TABLE', 'db1', '%', 'YES', 'YES');
14 insert into performance_schema.setup_objects
15 values ('TABLE', 'db2', 't1', 'YES', 'YES');
16 insert into performance_schema.setup_objects
17 values ('TABLE', 'db2', 't2', 'YES', 'NO');
18 insert into performance_schema.setup_objects
19 values ('TABLE', 'db3', 't1', 'YES', 'YES');
20 insert into performance_schema.setup_objects
21 values ('TABLE', 'db3', 't2', 'NO', 'NO');
22 insert into performance_schema.setup_objects
23 values ('TABLE', 'db3', '%', 'NO', 'YES');
24 insert into performance_schema.setup_objects
25 values ('TABLE', 'db4', 't1', 'NO', 'YES');
26 insert into performance_schema.setup_objects
27 values ('TABLE', 'db4', '%', 'YES', 'NO');
28 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
29 insert into performance_schema.setup_objects
30 values ('SOMETHING', 'bad1', 'bad1', 'YES', 'NO');
31 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails ()
32 show warnings;
33 Level Code Message
34 Warning 1265 Data truncated for column 'OBJECT_TYPE' at row 1
35 Error 1452 Cannot add or update a child row: a foreign key constraint fails ()
36 insert into performance_schema.setup_objects
37 values ('TABLE', 'bad2', 'bad2', 'MAYBE', 'NO');
38 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails ()
39 show warnings;
40 Level Code Message
41 Warning 1265 Data truncated for column 'ENABLED' at row 1
42 Error 1452 Cannot add or update a child row: a foreign key constraint fails ()
43 insert into performance_schema.setup_objects
44 values ('TABLE', 'bad3', 'bad3', 'YES', 'MAYBE NOT');
45 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails ()
46 show warnings;
47 Level Code Message
48 Warning 1265 Data truncated for column 'TIMED' at row 1
49 Error 1452 Cannot add or update a child row: a foreign key constraint fails ()
50 select * from performance_schema.setup_objects
51 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
52 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
53 TABLE db1 % YES YES
54 TABLE db1 t1 YES YES
55 TABLE db1 t2 YES NO
56 TABLE db2 t1 YES YES
57 TABLE db2 t2 YES NO
58 TABLE db3 % NO YES
59 TABLE db3 t1 YES YES
60 TABLE db3 t2 NO NO
61 TABLE db4 % YES NO
62 TABLE db4 t1 NO YES
63 update performance_schema.setup_objects
64 set OBJECT_TYPE='SOMETHING' where OBJECT_SCHEMA='db1' and OBJECT_NAME='t1';
65 ERROR HY000: Invalid performance_schema usage.
66 update performance_schema.setup_objects
67 set ENABLED='MAYBE' where OBJECT_SCHEMA='db1' and OBJECT_NAME='t1';
68 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails ()
69 update performance_schema.setup_objects
70 set TIMED='MAYBE NOT' where OBJECT_SCHEMA='db1' and OBJECT_NAME='t1';
71 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails ()
72 select * from performance_schema.setup_objects
73 order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME;
74 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
75 TABLE db1 % YES YES
76 TABLE db1 t1 YES YES
77 TABLE db1 t2 YES NO
78 TABLE db2 t1 YES YES
79 TABLE db2 t2 YES NO
80 TABLE db3 % NO YES
81 TABLE db3 t1 YES YES
82 TABLE db3 t2 NO NO
83 TABLE db4 % YES NO
84 TABLE db4 t1 NO YES
85 SET sql_mode = default;
86 drop database if exists db1;
87 drop database if exists db2;
88 drop database if exists db3;
89 drop database if exists db4;
90 drop database if exists db5;
91 create database db1;
92 create database db2;
93 create database db3;
94 create database db4;
95 create database db5;
96 create table db1.t1(a int);
97 create table db1.t2(a int);
98 create table db1.t3(a int);
99 create table db1.t4(a int);
100 create table db1.t5(a int);
101 create table db2.t1(a int);
102 create table db2.t2(a int);
103 create table db2.t3(a int);
104 create table db2.t4(a int);
105 create table db2.t5(a int);
106 create table db3.t1(a int);
107 create table db3.t2(a int);
108 create table db3.t3(a int);
109 create table db3.t4(a int);
110 create table db3.t5(a int);
111 create table db4.t1(a int);
112 create table db4.t2(a int);
113 create table db4.t3(a int);
114 create table db4.t4(a int);
115 create table db4.t5(a int);
116 create table db5.t1(a int);
117 select * from db1.t1;
118 a
119 select * from db1.t2;
120 a
121 select * from db1.t3;
122 a
123 select * from db1.t4;
124 a
125 select * from db1.t5;
126 a
127 select * from db2.t1;
128 a
129 select * from db2.t2;
130 a
131 select * from db2.t3;
132 a
133 select * from db2.t4;
134 a
135 select * from db2.t5;
136 a
137 select * from db3.t1;
138 a
139 select * from db3.t2;
140 a
141 select * from db3.t3;
142 a
143 select * from db3.t4;
144 a
145 select * from db3.t5;
146 a
147 select * from db4.t1;
148 a
149 select * from db4.t2;
150 a
151 select * from db4.t3;
152 a
153 select * from db4.t4;
154 a
155 select * from db4.t5;
156 a
157 select * from db5.t1;
158 a
159 create table db5.t2(a int);
160 select * from db3.t2;
161 a
162 select distinct OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA
163 from performance_schema.events_waits_history_long
164 where OBJECT_SCHEMA like "db%"
165 group by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA
166 order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA;
167 OBJECT_TYPE OBJECT_NAME OBJECT_SCHEMA
168 TABLE t1 db1
169 TABLE t1 db2
170 TABLE t1 db3
171 TABLE t2 db1
172 TABLE t2 db2
173 TABLE t2 db4
174 TABLE t3 db1
175 TABLE t3 db4
176 TABLE t4 db1
177 TABLE t4 db4
178 TABLE t5 db1
179 TABLE t5 db4
180 select distinct OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA
181 from performance_schema.events_waits_history_long
182 where OBJECT_SCHEMA like "db%" and TIMER_END is not NULL
183 group by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA
184 order by OBJECT_TYPE, OBJECT_NAME, OBJECT_SCHEMA;
185 OBJECT_TYPE OBJECT_NAME OBJECT_SCHEMA
186 TABLE t1 db1
187 TABLE t1 db2
188 TABLE t1 db3
189 TABLE t3 db1
190 TABLE t4 db1
191 TABLE t5 db1
192 update performance_schema.setup_objects
193 set timed='YES' where OBJECT_SCHEMA = '%';
194 create table db5.t3(a int);
195 select * from db3.t3;
196 a
197 truncate table performance_schema.setup_objects;
198 select count(*) from performance_schema.setup_objects;
199 count(*)
200 0
201 drop database db1;
202 drop database db2;
203 drop database db3;
204 drop database db4;
205 drop database db5;
206 truncate table performance_schema.setup_objects;
207 insert into performance_schema.setup_objects select * from test.setup_objects;
208 drop table test.setup_objects;
209 update performance_schema.setup_instruments set enabled='YES', timed='YES';