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 insert into performance_schema.setup_objects
19 set object_type='ILLEGAL', object_schema='foo', object_name='bar',
20 enabled='YES', timed='YES';
21 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails ()
22 insert into performance_schema.setup_objects
23 set object_type='TABLE', object_schema='foo', object_name='bar',
24 enabled='YES', timed='YES';
25 insert into performance_schema.setup_objects
26 set object_type='TABLE', object_schema='foo', object_name='bar',
27 enabled='YES', timed='NO';
28 ERROR 23000: Can't write; duplicate key in table 'setup_objects'
29 delete from performance_schema.setup_objects
30 where object_type='TABLE' and object_schema='foo';
31 select * from performance_schema.setup_objects
32 order by object_type, object_schema, object_name;
33 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
34 insert into performance_schema.setup_objects
35 set object_type='TABLE', object_schema='foo', object_name='bar',
36 enabled='NO', timed='YES';
37 select * from performance_schema.setup_objects
38 order by object_type, object_schema, object_name;
39 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
40 TABLE foo bar NO YES
41 update performance_schema.setup_objects
42 set object_type='ILLEGAL';
43 ERROR HY000: Invalid performance_schema usage.
44 update performance_schema.setup_objects
45 set object_schema='ILLEGAL';
46 ERROR HY000: Invalid performance_schema usage.
47 update performance_schema.setup_objects
48 set object_name='ILLEGAL';
49 ERROR HY000: Invalid performance_schema usage.
50 update performance_schema.setup_objects
51 set enabled='NO', timed='NO';
52 select * from performance_schema.setup_objects
53 order by object_type, object_schema, object_name;
54 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
55 TABLE foo bar NO NO
56 update performance_schema.setup_objects
57 set enabled='YES', timed='YES';
58 delete from performance_schema.setup_objects
59 where object_type = 'TABLE';
60 delete from performance_schema.setup_objects;
61 LOCK TABLES performance_schema.setup_objects READ;
62 UNLOCK TABLES;
63 LOCK TABLES performance_schema.setup_objects WRITE;
64 UNLOCK TABLES;
65 truncate table performance_schema.setup_objects;
66 insert into performance_schema.setup_objects
67 select * from test.setup_objects;
68 drop table test.setup_objects;
69 SET sql_mode = default;