Debian Codegraph @

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

raw
1 select * from performance_schema.threads
2 where name like 'Thread/%' limit 1;
3 select * from performance_schema.threads
4 where name='FOO';
5 insert into performance_schema.threads
6 set name='FOO', thread_id=1, processlist_id=2;
7 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'threads'
8 update performance_schema.threads
9 set thread_id=12;
10 ERROR HY000: Invalid performance_schema usage.
11 update performance_schema.threads
12 set thread_id=12 where PROCESSLIST_ID=connection_id();
13 ERROR HY000: Invalid performance_schema usage.
14 update performance_schema.threads
15 set instrumented= 'NO' where PROCESSLIST_ID=connection_id();
16 select instrumented from performance_schema.threads
17 where PROCESSLIST_ID=connection_id();
18 instrumented
19 NO
20 update performance_schema.threads
21 set instrumented= 'YES' where PROCESSLIST_ID=connection_id();
22 select instrumented from performance_schema.threads
23 where PROCESSLIST_ID=connection_id();
24 instrumented
25 YES
26 update performance_schema.threads
27 set resource_group = 'FOO' where PROCESSLIST_ID=connection_id();
28 ERROR HY000: Invalid performance_schema usage.
29 update performance_schema.threads
30 set execution_engine='SECONDARY';
31 ERROR HY000: Invalid performance_schema usage.
32 delete from performance_schema.threads
33 where id=1;
34 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'threads'
35 delete from performance_schema.threads;
36 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'threads'
37 LOCK TABLES performance_schema.threads READ;
38 UNLOCK TABLES;
39 LOCK TABLES performance_schema.threads WRITE;
40 UNLOCK TABLES;