Debian Codegraph @

mysql-test/suite/innodb/r/instant_ddl_recovery_old_2.result

raw
1 #########
2 # SETUP #
3 #########
4 # Stop the running the server
5 # Copy and unzip the datadir.
6 # Restart the server against the unzipped datadir
7 # restart: --datadir=DATADIR --innodb-page-size=16k
8 ##############################################
9 # Test instant ADD COLUMN for REDUNDANT format
10 ##############################################
11 #########
12 # SETUP #
13 #########
14 # Metadata from INFORMATION_SCHEMA.TABLES
15 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
16 test/t1_redundant 6 2 0 3 3 3
17 # Metadata from INFORMATION_SCHEMA.COLUMNS
18 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
19 c1 0 13 16711934 0 0 0
20 c2 1 13 16711934 0 0 0
21 c3 2 13 16711934 1 0 0
22 # DD Metadata of table
23 NAME SE_PRIVATE_DATA
24 t1_redundant instant_col=2;
25 # DD Metadata of columns in table
26 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
27 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
28 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
29 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
30 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
31 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
32 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
33 SELECT * FROM t1_redundant;
34 c1 c2 c3
35 r1c1 r1c2 NULL
36 SET GLOBAL innodb_log_checkpoint_now = ON;
37 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
38 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
39 SET GLOBAL innodb_master_thread_disabled_debug = 1;
40 INSERT INTO t1_redundant VALUES ("r2c1", "r2c2", "r2c3");
41 # Restart running server.
42 SELECT * FROM t1_redundant;
43 c1 c2 c3
44 r1c1 r1c2 NULL
45 r2c1 r2c2 r2c3
46 # Metadata from INFORMATION_SCHEMA.TABLES
47 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
48 test/t1_redundant 6 2 0 3 3 3
49 # Metadata from INFORMATION_SCHEMA.COLUMNS
50 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
51 c1 0 13 16711934 0 0 0
52 c2 1 13 16711934 0 0 0
53 c3 2 13 16711934 1 0 0
54 # DD Metadata of table
55 NAME SE_PRIVATE_DATA
56 t1_redundant instant_col=2;
57 # DD Metadata of columns in table
58 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
59 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
60 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
61 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
62 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
63 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
64 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
65 ###########
66 # CLEANUP #
67 ###########
68 DROP TABLE t1_redundant;
69 ############################################
70 # Test instant ADD COLUMN for DYNAMIC format
71 ############################################
72 #########
73 # SETUP #
74 #########
75 # Metadata from INFORMATION_SCHEMA.TABLES
76 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
77 test/t1_dynamic 6 2 0 3 3 3
78 # Metadata from INFORMATION_SCHEMA.COLUMNS
79 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
80 c1 0 13 16711934 0 0 0
81 c2 1 13 16711934 0 0 0
82 c3 2 13 16711934 1 0 0
83 # DD Metadata of table
84 NAME SE_PRIVATE_DATA
85 t1_dynamic instant_col=2;
86 # DD Metadata of columns in table
87 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
88 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
89 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
90 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
91 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
92 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
93 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
94 SELECT * FROM t1_dynamic;
95 c1 c2 c3
96 r1c1 r1c2 NULL
97 SET GLOBAL innodb_log_checkpoint_now = ON;
98 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
99 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
100 SET GLOBAL innodb_master_thread_disabled_debug = 1;
101 INSERT INTO t1_dynamic VALUES ("r2c1", "r2c2", "r2c3");
102 # Restart running server.
103 SELECT * FROM t1_dynamic;
104 c1 c2 c3
105 r1c1 r1c2 NULL
106 r2c1 r2c2 r2c3
107 # Metadata from INFORMATION_SCHEMA.TABLES
108 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
109 test/t1_dynamic 6 2 0 3 3 3
110 # Metadata from INFORMATION_SCHEMA.COLUMNS
111 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
112 c1 0 13 16711934 0 0 0
113 c2 1 13 16711934 0 0 0
114 c3 2 13 16711934 1 0 0
115 # DD Metadata of table
116 NAME SE_PRIVATE_DATA
117 t1_dynamic instant_col=2;
118 # DD Metadata of columns in table
119 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
120 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
121 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
122 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
123 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
124 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
125 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
126 ###########
127 # CLEANUP #
128 ###########
129 DROP TABLE t1_dynamic;
130 ############################################
131 # Test instant ADD COLUMN for COMPACT format
132 ############################################
133 #########
134 # SETUP #
135 #########
136 # Metadata from INFORMATION_SCHEMA.TABLES
137 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
138 test/t1_compact 6 2 0 3 3 3
139 # Metadata from INFORMATION_SCHEMA.COLUMNS
140 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
141 c1 0 13 16711934 0 0 0
142 c2 1 13 16711934 0 0 0
143 c3 2 13 16711934 1 0 0
144 # DD Metadata of table
145 NAME SE_PRIVATE_DATA
146 t1_compact instant_col=2;
147 # DD Metadata of columns in table
148 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
149 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
150 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
151 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
152 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
153 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
154 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
155 SELECT * FROM t1_compact;
156 c1 c2 c3
157 r1c1 r1c2 NULL
158 SET GLOBAL innodb_log_checkpoint_now = ON;
159 SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
160 SET GLOBAL innodb_dict_stats_disabled_debug = 1;
161 SET GLOBAL innodb_master_thread_disabled_debug = 1;
162 INSERT INTO t1_compact VALUES ("r2c1", "r2c2", "r2c3");
163 # Restart running server.
164 SELECT * FROM t1_compact;
165 c1 c2 c3
166 r1c1 r1c2 NULL
167 r2c1 r2c2 r2c3
168 # Metadata from INFORMATION_SCHEMA.TABLES
169 NAME N_COLS INSTANT_COLS TOTAL_ROW_VERSIONS INITIAL_COLUMN_COUNTS CURRENT_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
170 test/t1_compact 6 2 0 3 3 3
171 # Metadata from INFORMATION_SCHEMA.COLUMNS
172 NAME POS MTYPE PRTYPE HAS_DEFAULT VERSION_ADDED VERSION_DROPPED
173 c1 0 13 16711934 0 0 0
174 c2 1 13 16711934 0 0 0
175 c3 2 13 16711934 1 0 0
176 # DD Metadata of table
177 NAME SE_PRIVATE_DATA
178 t1_compact instant_col=2;
179 # DD Metadata of columns in table
180 NAME ORDINAL_POSITION TYPE HAS_NO_DEFAULT HIDDEN SE_PRIVATE_DATA
181 c1 1 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
182 c2 2 MYSQL_TYPE_STRING 0 Visible table_id=TABLE_ID;
183 c3 3 MYSQL_TYPE_STRING 0 Visible default_null=1;table_id=TABLE_ID;
184 DB_ROW_ID 4 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
185 DB_TRX_ID 5 MYSQL_TYPE_INT24 0 SE table_id=TABLE_ID;
186 DB_ROLL_PTR 6 MYSQL_TYPE_LONGLONG 0 SE table_id=TABLE_ID;
187 ###########
188 # CLEANUP #
189 ###########
190 DROP TABLE t1_compact;
191 ###########
192 # CLEANUP #
193 ###########
194 # Shutdown server
195 # Remove copied files
196 # Restarting server to restore server state
197 # restart