Debian Codegraph @

mysql-test/suite/perfschema/r/table_component_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_continent;
8 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
9 show create table performance_schema.pfs_example_continent;
10 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
11 select * from performance_schema.pfs_example_continent;
12 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
13 ###########
14 # INSTALL #
15 ###########
16 INSTALL COMPONENT "file://component_pfs_example_component_population";
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_continent PERFORMANCE_SCHEMA 10
23 performance_schema pfs_example_country PERFORMANCE_SCHEMA 10
24 describe performance_schema.pfs_example_continent;
25 Field Type Null Key Default Extra
26 NAME char(20) NO PRI NULL
27 show create table performance_schema.pfs_example_continent;
28 Table Create Table
29 pfs_example_continent CREATE TABLE `pfs_example_continent` (
30 `NAME` char(20) NOT NULL,
31 PRIMARY KEY (`NAME`)
32 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
33 select * from performance_schema.pfs_example_continent;
34 NAME
35 bar1
36 bar2
37 ##############
38 # UN INSTALL #
39 ##############
40 UNINSTALL COMPONENT "file://component_pfs_example_component_population";
41 select * from INFORMATION_SCHEMA.tables
42 where TABLE_NAME like "pfs_example_%";
43 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
44 describe performance_schema.pfs_example_continent;
45 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
46 show create table performance_schema.pfs_example_continent;
47 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
48 select * from performance_schema.pfs_example_continent;
49 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
50 ################################
51 # SERVER RESTART, UN INSTALLED #
52 ################################
53 # restart
54 select * from INFORMATION_SCHEMA.tables
55 where TABLE_NAME like "pfs_example_%";
56 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
57 describe performance_schema.pfs_example_continent;
58 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
59 show create table performance_schema.pfs_example_continent;
60 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
61 select * from performance_schema.pfs_example_continent;
62 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
63 ###########
64 # INSTALL #
65 ###########
66 INSTALL COMPONENT "file://component_pfs_example_component_population";
67 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
68 from INFORMATION_SCHEMA.tables
69 where TABLE_NAME like "pfs_example_%"
70 order by table_name;
71 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
72 performance_schema pfs_example_continent PERFORMANCE_SCHEMA 10
73 performance_schema pfs_example_country PERFORMANCE_SCHEMA 10
74 describe performance_schema.pfs_example_continent;
75 Field Type Null Key Default Extra
76 NAME char(20) NO PRI NULL
77 show create table performance_schema.pfs_example_continent;
78 Table Create Table
79 pfs_example_continent CREATE TABLE `pfs_example_continent` (
80 `NAME` char(20) NOT NULL,
81 PRIMARY KEY (`NAME`)
82 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
83 select * from performance_schema.pfs_example_continent;
84 NAME
85 bar1
86 bar2
87 #############################
88 # SERVER RESTART, INSTALLED #
89 #############################
90 # restart
91 select TABLE_SCHEMA, TABLE_NAME, ENGINE, VERSION, TABLE_COMMENT
92 from INFORMATION_SCHEMA.tables
93 where TABLE_NAME like "pfs_example_%"
94 order by table_name;
95 TABLE_SCHEMA TABLE_NAME ENGINE VERSION TABLE_COMMENT
96 performance_schema pfs_example_continent PERFORMANCE_SCHEMA 10
97 performance_schema pfs_example_country PERFORMANCE_SCHEMA 10
98 describe performance_schema.pfs_example_continent;
99 Field Type Null Key Default Extra
100 NAME char(20) NO PRI NULL
101 show create table performance_schema.pfs_example_continent;
102 Table Create Table
103 pfs_example_continent CREATE TABLE `pfs_example_continent` (
104 `NAME` char(20) NOT NULL,
105 PRIMARY KEY (`NAME`)
106 ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
107 select * from performance_schema.pfs_example_continent;
108 NAME
109 bar1
110 bar2
111 ##############
112 # UN INSTALL #
113 ##############
114 UNINSTALL COMPONENT "file://component_pfs_example_component_population";
115 select * from INFORMATION_SCHEMA.tables
116 where TABLE_NAME like "pfs_example_%";
117 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
118 describe performance_schema.pfs_example_continent;
119 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
120 show create table performance_schema.pfs_example_continent;
121 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
122 select * from performance_schema.pfs_example_continent;
123 ERROR 42S02: Table 'performance_schema.pfs_example_continent' doesn't exist
124 ###########
125 # CLEANUP #
126 ###########
127 pfs_example_component_population init:
128 Passed add_tables()
129 End of init
130
131 pfs_example_component_population_deinit:
132 Passed delete_tables()
133 End of deinit
134