Debian Codegraph @

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

raw
1 select * from performance_schema.data_locks;
2 select * from performance_schema.data_locks
3 where object_name='foo';
4 ENGINE ENGINE_LOCK_ID ENGINE_TRANSACTION_ID THREAD_ID EVENT_ID OBJECT_SCHEMA OBJECT_NAME PARTITION_NAME SUBPARTITION_NAME INDEX_NAME OBJECT_INSTANCE_BEGIN LOCK_TYPE LOCK_MODE LOCK_STATUS LOCK_DATA
5 insert into performance_schema.data_locks
6 set object_name='FOO', thread_id=1;
7 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'data_locks'
8 update performance_schema.data_locks
9 set thread_id=12 where object_name='foo';
10 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'data_locks'
11 delete from performance_schema.data_locks;
12 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'data_locks'
13 delete from performance_schema.data_locks
14 where lock_mode='CYCLE';
15 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'data_locks'
16 LOCK TABLES performance_schema.data_locks READ;
17 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'data_locks'
18 UNLOCK TABLES;
19 LOCK TABLES performance_schema.data_locks WRITE;
20 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'data_locks'
21 UNLOCK TABLES;