Debian Codegraph @

mysql-test/suite/perfschema/t/dml_tls_channel_status.test

raw
1 --disable_result_log
2 SELECT * FROM performance_schema.tls_channel_status
3 LIMIT 1;
4
5 SELECT * FROM performance_schema.tls_channel_status
6 where CHANNEL ='FOO' OR PROPERTY='BAR';
7 --enable_result_log
8
9 --error ER_TABLEACCESS_DENIED_ERROR
10 INSERT INTO performance_schema.tls_channel_status
11 SET CHANNEL='FOO', PROPERTY='BAR', VALUE='BAZ';
12
13 --error ER_TABLEACCESS_DENIED_ERROR
14 UPDATE performance_schema.tls_channel_status
15 SET CHANNEL='FOO';
16
17 --error ER_TABLEACCESS_DENIED_ERROR
18 UPDATE performance_schema.tls_channel_status
19 SET CHANNEL='FOO' WHERE PROPERTY='BAR';
20
21 --error ER_TABLEACCESS_DENIED_ERROR
22 DELETE FROM performance_schema.tls_channel_status
23 WHERE VALUE='BAR';
24
25 --error ER_TABLEACCESS_DENIED_ERROR
26 DELETE FROM performance_schema.tls_channel_status;
27
28 -- error ER_TABLEACCESS_DENIED_ERROR
29 LOCK TABLES performance_schema.tls_channel_status READ;
30 UNLOCK TABLES;
31
32 -- error ER_TABLEACCESS_DENIED_ERROR
33 LOCK TABLES performance_schema.tls_channel_status WRITE;
34 UNLOCK TABLES;