Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source include/not_embedded.inc
4 --source include/have_perfschema.inc
5 --source include/have_innodb.inc
6
7 --disable_result_log
8 select * from performance_schema.file_instances limit 1;
9
10 select * from performance_schema.file_instances
11 where file_name='FOO';
12 --enable_result_log
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 insert into performance_schema.file_instances
16 set file_name='FOO', event_name='BAR', open_count=12;
17
18 --error ER_TABLEACCESS_DENIED_ERROR
19 update performance_schema.file_instances
20 set file_name='FOO';
21
22 --error ER_TABLEACCESS_DENIED_ERROR
23 delete from performance_schema.file_instances
24 where event_name like "wait/%";
25
26 --error ER_TABLEACCESS_DENIED_ERROR
27 delete from performance_schema.file_instances;
28
29 -- error ER_TABLEACCESS_DENIED_ERROR
30 LOCK TABLES performance_schema.file_instances READ;
31 UNLOCK TABLES;
32
33 -- error ER_TABLEACCESS_DENIED_ERROR
34 LOCK TABLES performance_schema.file_instances WRITE;
35 UNLOCK TABLES;
36
37 --echo #
38 --echo # MDEV-25325 column_comment for performance_schema tables
39 --echo #
40 select column_name, column_comment
41 from information_schema.columns
42 where table_schema='performance_schema' and table_name='file_instances';
43
44 --echo ###
45 --echo ### Bug#26152751: INNODB LEAKS MEMORY, PERFORMANCE_SCHEMA FILE_INSTANCES
46 --echo ### #SQL-IB3129987-252773.IBD
47 --echo ###
48
49 CREATE DATABASE db_26152751;
50 USE db_26152751;
51
52 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
53
54 CREATE TABLE t_db_26152751 (a INT) ENGINE=MYISAM;
55
56 --sorted_result
57 --replace_regex /.*\/t_db_26152751/t_db_26152751/
58 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
59
60 RENAME TABLE t_db_26152751 to t_db_26152751_new;
61
62 --sorted_result
63 --replace_regex /.*\/t_db_26152751/t_db_26152751/
64 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
65
66 RENAME TABLE t_db_26152751_new to t_db_26152751;
67
68 --sorted_result
69 --replace_regex /.*\/t_db_26152751/t_db_26152751/
70 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
71
72 ALTER TABLE t_db_26152751 ADD COLUMN b INT;
73
74 --replace_regex /.*\/t_db_26152751/t_db_26152751/
75 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
76
77 DROP TABLE t_db_26152751;
78
79 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
80
81 CREATE TABLE t_db_26152751 (a INT) ENGINE=INNODB;
82
83 --replace_regex /.*\/t_db_26152751/t_db_26152751/
84 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
85
86 RENAME TABLE t_db_26152751 to t_db_26152751_new;
87
88 --replace_regex /.*\/t_db_26152751/t_db_26152751/
89 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
90
91 RENAME TABLE t_db_26152751_new to t_db_26152751;
92
93 --replace_regex /.*\/t_db_26152751/t_db_26152751/
94 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
95
96 ALTER TABLE t_db_26152751 ADD COLUMN b INT;
97
98 --replace_regex /.*\/t_db_26152751/t_db_26152751/
99 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
100
101 DROP TABLE t_db_26152751;
102
103 SELECT FILE_NAME FROM performance_schema.file_instances WHERE FILE_NAME LIKE "%t_db_26152751%" ORDER BY FILE_NAME;
104
105 DROP DATABASE db_26152751;
106
107
108 --echo #
109 --echo # MDEV-25325 column_comment for performance_schema tables
110 --echo #
111 select column_name, column_comment
112 from information_schema.columns
113 where table_schema='performance_schema' and table_name='file_instances';