Debian Codegraph @

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

raw
1 drop table if exists test.setup_objects;
2 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
3 create table test.setup_objects as
4 select * from performance_schema.setup_objects;
5 truncate table performance_schema.setup_objects;
6 select * from performance_schema.setup_objects;
7 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
8 select * from performance_schema.setup_objects
9 order by object_type, object_schema, object_name;
10 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
11 select * from performance_schema.setup_objects
12 where object_type = 'TABLE'
13 order by object_type, object_schema, object_name;
14 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
15 select * from performance_schema.setup_objects
16 order by object_type, object_schema, object_name;
17 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
18 set sql_mode= '';
19 insert into performance_schema.setup_objects
20 set object_type='ILLEGAL', object_schema='FOO', object_name='BAR',
21 enabled='YES', timed='YES';
22 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails
23 set sql_mode= DEFAULT;
24 insert into performance_schema.setup_objects
25 set object_type='TABLE', object_schema='FOO', object_name='BAR',
26 enabled='YES', timed='YES';
27 insert into performance_schema.setup_objects
28 set object_type='TABLE', object_schema='FOO', object_name='BAR',
29 enabled='YES', timed='NO';
30 ERROR 23000: Can't write; duplicate key in table 'setup_objects'
31 delete from performance_schema.setup_objects
32 where object_type='TABLE' and object_schema='FOO';
33 select * from performance_schema.setup_objects
34 order by object_type, object_schema, object_name;
35 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
36 insert into performance_schema.setup_objects
37 set object_type='TABLE', object_schema='FOO', object_name='BAR',
38 enabled='NO', timed='YES';
39 select * from performance_schema.setup_objects
40 order by object_type, object_schema, object_name;
41 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
42 TABLE FOO BAR NO YES
43 set statement sql_mode = '' for
44 update performance_schema.setup_objects
45 set object_type='ILLEGAL';
46 ERROR HY000: Invalid performance_schema usage
47 update performance_schema.setup_objects
48 set object_schema='ILLEGAL';
49 ERROR HY000: Invalid performance_schema usage
50 update performance_schema.setup_objects
51 set object_name='ILLEGAL';
52 ERROR HY000: Invalid performance_schema usage
53 update performance_schema.setup_objects
54 set enabled='NO', timed='NO';
55 select * from performance_schema.setup_objects
56 order by object_type, object_schema, object_name;
57 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
58 TABLE FOO BAR NO NO
59 update performance_schema.setup_objects
60 set enabled='YES', timed='YES';
61 delete from performance_schema.setup_objects
62 where object_type = 'TABLE';
63 delete from performance_schema.setup_objects;
64 LOCK TABLES performance_schema.setup_objects READ;
65 UNLOCK TABLES;
66 LOCK TABLES performance_schema.setup_objects WRITE;
67 UNLOCK TABLES;
68 truncate table performance_schema.setup_objects;
69 insert into performance_schema.setup_objects
70 select * from test.setup_objects;
71 drop table test.setup_objects;
72 SET sql_mode = default;
73 #
74 # MDEV-25325 column_comment for performance_schema tables
75 #
76 select column_name, column_comment
77 from information_schema.columns
78 where table_schema='performance_schema' and table_name='setup_objects';
79 column_name column_comment
80 OBJECT_TYPE Type of object to instrument.
81 OBJECT_SCHEMA Schema containing the object, either the literal or % for any schema.
82 OBJECT_NAME Name of the instrumented object, either the literal or % for any object.
83 ENABLED Whether the object's events are instrumented or not. Can be disabled, in which case monitoring is not enabled for those objects.
84 TIMED Whether the object's events are timed or not. Can be modified.