Debian Codegraph @

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

raw
1 #################
2 # INITIAL STATE #
3 #################
4 select * from INFORMATION_SCHEMA.tables
5 where TABLE_NAME like "pfs_example_%";
6 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
7 describe performance_schema.pfs_example_employee_name;
8 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
9 show create table performance_schema.pfs_example_employee_name;
10 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
11 select * from performance_schema.pfs_example_employee_name;
12 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
13 ###########
14 # INSTALL #
15 ###########
16 INSTALL PLUGIN pfs_example_plugin_employee SONAME 'pfs_example_plugin_employee.xxx';
17 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
18 from INFORMATION_SCHEMA.tables
19 where TABLE_NAME like "pfs_example_%"
20 order by table_name;
21 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
22 performance_schema pfs_example_employee_name PERFORMANCE_SCHEMA 10
23 performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
24 performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
25 performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
26 describe performance_schema.pfs_example_employee_name;
27 Field Type Null Key Default Extra
28 EMPLOYEE_NUMBER int NO PRI NULL
29 FIRST_NAME char(20) YES MUL NULL
30 LAST_NAME varchar(20) YES NULL
31 show create table performance_schema.pfs_example_employee_name;
32 Table Create Table
33 pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
34 `EMPLOYEE_NUMBER` int NOT NULL,
35 `FIRST_NAME` char(20) DEFAULT NULL,
36 `LAST_NAME` varchar(20) DEFAULT NULL,
37 PRIMARY KEY (`EMPLOYEE_NUMBER`),
38 KEY `FIRST_NAME` (`FIRST_NAME`)
39 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
40 select * from performance_schema.pfs_example_employee_name;
41 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
42 1 foo1 bar1
43 2 foo2 bar2
44 3 foo3 bar3
45 ##############
46 # UN INSTALL #
47 ##############
48 UNINSTALL PLUGIN pfs_example_plugin_employee;
49 select * from INFORMATION_SCHEMA.tables
50 where TABLE_NAME like "pfs_example_%";
51 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
52 describe performance_schema.pfs_example_employee_name;
53 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
54 show create table performance_schema.pfs_example_employee_name;
55 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
56 select * from performance_schema.pfs_example_employee_name;
57 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
58 insert into performance_schema.pfs_example_employee_name
59 values (1, "First", "Last");
60 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
61 update performance_schema.pfs_example_employee_name
62 set employee_number = 2 where employee_number = 1;
63 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
64 delete from performance_schema.pfs_example_employee_name;
65 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
66 ##########################################
67 # SERVER RESTART, AFTER PLUGIN UNINSTALL #
68 ##########################################
69 # restart
70 select * from INFORMATION_SCHEMA.tables
71 where TABLE_NAME like "pfs_example_%";
72 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
73 describe performance_schema.pfs_example_employee_name;
74 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
75 show create table performance_schema.pfs_example_employee_name;
76 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
77 select * from performance_schema.pfs_example_employee_name;
78 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
79 ###########
80 # INSTALL #
81 ###########
82 INSTALL PLUGIN pfs_example_plugin_employee SONAME 'pfs_example_plugin_employee.xxx';
83 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
84 from INFORMATION_SCHEMA.tables
85 where TABLE_NAME like "pfs_example_%"
86 order by table_name;
87 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
88 performance_schema pfs_example_employee_name PERFORMANCE_SCHEMA 10
89 performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
90 performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
91 performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
92 describe performance_schema.pfs_example_employee_name;
93 Field Type Null Key Default Extra
94 EMPLOYEE_NUMBER int NO PRI NULL
95 FIRST_NAME char(20) YES MUL NULL
96 LAST_NAME varchar(20) YES NULL
97 show create table performance_schema.pfs_example_employee_name;
98 Table Create Table
99 pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
100 `EMPLOYEE_NUMBER` int NOT NULL,
101 `FIRST_NAME` char(20) DEFAULT NULL,
102 `LAST_NAME` varchar(20) DEFAULT NULL,
103 PRIMARY KEY (`EMPLOYEE_NUMBER`),
104 KEY `FIRST_NAME` (`FIRST_NAME`)
105 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
106 select * from performance_schema.pfs_example_employee_name;
107 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
108 1 foo1 bar1
109 2 foo2 bar2
110 3 foo3 bar3
111 ############################################
112 # SERVER RESTART, WITHOUT PLUGIN UNINSTALL #
113 ############################################
114 # restart
115 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
116 from INFORMATION_SCHEMA.tables
117 where TABLE_NAME like "pfs_example_%"
118 order by table_name;
119 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
120 performance_schema pfs_example_employee_name PERFORMANCE_SCHEMA 10
121 performance_schema pfs_example_employee_salary PERFORMANCE_SCHEMA 10
122 performance_schema pfs_example_machine PERFORMANCE_SCHEMA 10
123 performance_schema pfs_example_machine_by_employee_by_type PERFORMANCE_SCHEMA 10
124 describe performance_schema.pfs_example_employee_name;
125 Field Type Null Key Default Extra
126 EMPLOYEE_NUMBER int NO PRI NULL
127 FIRST_NAME char(20) YES MUL NULL
128 LAST_NAME varchar(20) YES NULL
129 show create table performance_schema.pfs_example_employee_name;
130 Table Create Table
131 pfs_example_employee_name CREATE TABLE `pfs_example_employee_name` (
132 `EMPLOYEE_NUMBER` int NOT NULL,
133 `FIRST_NAME` char(20) DEFAULT NULL,
134 `LAST_NAME` varchar(20) DEFAULT NULL,
135 PRIMARY KEY (`EMPLOYEE_NUMBER`),
136 KEY `FIRST_NAME` (`FIRST_NAME`)
137 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
138 select * from performance_schema.pfs_example_employee_name;
139 EMPLOYEE_NUMBER FIRST_NAME LAST_NAME
140 1 foo1 bar1
141 2 foo2 bar2
142 3 foo3 bar3
143 ###########
144 # CLEANUP #
145 ###########
146 UNINSTALL PLUGIN pfs_example_plugin_employee;
147 select * from INFORMATION_SCHEMA.tables
148 where TABLE_NAME like "pfs_example_%";
149 TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
150 describe performance_schema.pfs_example_employee_name;
151 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
152 show create table performance_schema.pfs_example_employee_name;
153 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist
154 select * from performance_schema.pfs_example_employee_name;
155 ERROR 42S02: Table 'performance_schema.pfs_example_employee_name' doesn't exist