Debian Codegraph @

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

raw
1 select * from performance_schema.table_handles;
2 select * from performance_schema.table_handles
3 where object_name='foo';
4 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN OWNER_THREAD_ID OWNER_EVENT_ID INTERNAL_LOCK EXTERNAL_LOCK
5 insert into performance_schema.table_handles
6 set object_name='FOO', owner_event_id=1;
7 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'table_handles'
8 update performance_schema.table_handles
9 set owner_event_id=12 where object_name='foo';
10 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'table_handles'
11 delete from performance_schema.table_handles;
12 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'table_handles'
13 delete from performance_schema.table_handles
14 where timer_name='CYCLE';
15 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'table_handles'
16 LOCK TABLES performance_schema.table_handles READ;
17 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_handles'
18 UNLOCK TABLES;
19 LOCK TABLES performance_schema.table_handles WRITE;
20 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'table_handles'
21 UNLOCK TABLES;