Debian Codegraph @

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

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