Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5
6 --disable_result_log
7 select * from performance_schema.memory_summary_by_user_by_event_name
8 where event_name like 'memory/%' limit 1;
9
10 select * from performance_schema.memory_summary_by_user_by_event_name
11 where event_name='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.memory_summary_by_user_by_event_name
16 set event_name='FOO', user='BAR',
17 count_alloc=1, count_free=2, sum_number_of_bytes_alloc=3,
18 sum_number_of_bytes_free=4, low_count_used=5;
19
20 --error ER_TABLEACCESS_DENIED_ERROR
21 update performance_schema.memory_summary_by_user_by_event_name
22 set count_alloc=12;
23
24 --error ER_TABLEACCESS_DENIED_ERROR
25 update performance_schema.memory_summary_by_user_by_event_name
26 set count_alloc=12 where event_name like "FOO";
27
28 --error ER_TABLEACCESS_DENIED_ERROR
29 delete from performance_schema.memory_summary_by_user_by_event_name
30 where count_alloc=1;
31
32 --error ER_TABLEACCESS_DENIED_ERROR
33 delete from performance_schema.memory_summary_by_user_by_event_name;
34
35 -- error ER_TABLEACCESS_DENIED_ERROR
36 LOCK TABLES performance_schema.memory_summary_by_user_by_event_name READ;
37 UNLOCK TABLES;
38
39 -- error ER_TABLEACCESS_DENIED_ERROR
40 LOCK TABLES performance_schema.memory_summary_by_user_by_event_name WRITE;
41 UNLOCK TABLES;
42
43 --echo #
44 --echo # MDEV-25325 column_comment for performance_schema tables
45 --echo #
46 select column_name, column_comment
47 from information_schema.columns
48 where table_schema='performance_schema' and table_name='memory_summary_by_user_by_event_name';