Debian Codegraph @

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

raw
1 CREATE TABLE t1 (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES(42);
3 CREATE TABLE t1b LIKE t1;
4 INSERT INTO t1b VALUES(3);
5 CREATE TABLE t1z LIKE t1;
6 CREATE TABLE t1t (id TINYINT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
7 CREATE TABLE t0t LIKE t1t;
8 INSERT INTO t1t VALUES(123);
9 FLUSH TABLES t1,t1b,t1t FOR EXPORT;
10 UNLOCK TABLES;
11 CREATE TABLE t5_7 LIKE t1;
12 CREATE TABLE t5_7b LIKE t1b;
13 CREATE TABLE t10_1 LIKE t1;
14 CREATE TABLE t10_1b LIKE t1b;
15 ALTER TABLE t1 DISCARD TABLESPACE;
16 ALTER TABLE t1b DISCARD TABLESPACE;
17 ALTER TABLE t1z DISCARD TABLESPACE;
18 ALTER TABLE t1t DISCARD TABLESPACE;
19 ALTER TABLE t0t DISCARD TABLESPACE;
20 ALTER TABLE t5_7 DISCARD TABLESPACE;
21 ALTER TABLE t5_7b DISCARD TABLESPACE;
22 ALTER TABLE t10_1 DISCARD TABLESPACE;
23 ALTER TABLE t10_1b DISCARD TABLESPACE;
24 FLUSH TABLES;
25 ALTER TABLE t0t IMPORT TABLESPACE;
26 Warnings:
27 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t0t.cfg', will attempt to import without schema verification
28 INSERT INTO t0t VALUES(NULL);
29 SELECT * FROM t0t;
30 id
31 123
32 124
33 DROP TABLE t0t;
34 ALTER TABLE t1 IMPORT TABLESPACE;
35 Warnings:
36 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t1.cfg', will attempt to import without schema verification
37 ALTER TABLE t1b IMPORT TABLESPACE;
38 Warnings:
39 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t1b.cfg', will attempt to import without schema verification
40 ALTER TABLE t1z IMPORT TABLESPACE;
41 Warnings:
42 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t1z.cfg', will attempt to import without schema verification
43 ALTER TABLE t1t IMPORT TABLESPACE;
44 Warnings:
45 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t1t.cfg', will attempt to import without schema verification
46 ALTER TABLE t5_7 IMPORT TABLESPACE;
47 Warnings:
48 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t5_7.cfg', will attempt to import without schema verification
49 ALTER TABLE t5_7b IMPORT TABLESPACE;
50 Warnings:
51 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t5_7b.cfg', will attempt to import without schema verification
52 ALTER TABLE t10_1 IMPORT TABLESPACE;
53 Warnings:
54 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t10_1.cfg', will attempt to import without schema verification
55 ALTER TABLE t10_1b IMPORT TABLESPACE;
56 Warnings:
57 Warning 1810 IO Read error: (2, No such file or directory) Error opening './test/t10_1b.cfg', will attempt to import without schema verification
58 FOUND 1 /InnoDB: Resetting PAGE_ROOT_AUTO_INC from 128 to 123 on table `test`\.`t0t`/ in mysqld.1.err
59 FOUND 1 /InnoDB: Resetting PAGE_ROOT_AUTO_INC from 0 to 42 on table `test`\.`t1z`/ in mysqld.1.err
60 FOUND 1 /InnoDB: Resetting PAGE_ROOT_AUTO_INC from 128 to 123 on table `test`\.`t1t`/ in mysqld.1.err
61 FOUND 1 /InnoDB: Resetting PAGE_ROOT_AUTO_INC from 3 to 42 on table `test`\.`t5_7` \(created with version 50744\)/ in mysqld.1.err
62 FOUND 1 /InnoDB: Resetting PAGE_ROOT_AUTO_INC from 3 to 42 on table `test`\.`t10_1` \(created with version 100149\)/ in mysqld.1.err
63 FOUND 5 /InnoDB: Resetting PAGE_ROOT_AUTO_INC/ in mysqld.1.err
64 # restart: --read-only
65 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;
66 Table Op Msg_type Msg_text
67 test.t1 check status OK
68 test.t1b check status OK
69 test.t1t check status OK
70 test.t1z check status OK
71 test.t5_7 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
72 test.t5_7 check status OK
73 test.t5_7b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
74 test.t5_7b check status OK
75 test.t10_1 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
76 test.t10_1 check status OK
77 test.t10_1b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
78 test.t10_1b check status OK
79 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
80 Table Op Msg_type Msg_text
81 test.t1 check status OK
82 test.t1b check status OK
83 test.t1t check status OK
84 test.t1z check status OK
85 test.t5_7 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
86 test.t5_7 check status OK
87 test.t5_7b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
88 test.t5_7b check status OK
89 test.t10_1 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
90 test.t10_1 check status OK
91 test.t10_1b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
92 test.t10_1b check status OK
93 # restart: --innodb-read-only --read-only
94 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;
95 Table Op Msg_type Msg_text
96 test.t1 check status OK
97 test.t1b check status OK
98 test.t1t check status OK
99 test.t1z check status OK
100 test.t5_7 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
101 test.t5_7 check status OK
102 test.t5_7b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
103 test.t5_7b check status OK
104 test.t10_1 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
105 test.t10_1 check status OK
106 test.t10_1b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
107 test.t10_1b check status OK
108 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
109 Table Op Msg_type Msg_text
110 test.t1 check status OK
111 test.t1b check status OK
112 test.t1t check status OK
113 test.t1z check status OK
114 test.t5_7 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
115 test.t5_7 check status OK
116 test.t5_7b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
117 test.t5_7b check status OK
118 test.t10_1 check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
119 test.t10_1 check status OK
120 test.t10_1b check note Auto_increment will be checked on each open until CHECK TABLE FOR UPGRADE is executed when the server is not in a read-only state
121 test.t10_1b check status OK
122 # restart: --innodb-read-only
123 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;
124 Table Op Msg_type Msg_text
125 test.t1 check status OK
126 test.t1b check status OK
127 test.t1t check status OK
128 test.t1z check status OK
129 test.t5_7 check status Operation failed
130 test.t5_7b check status Operation failed
131 test.t10_1 check status Operation failed
132 test.t10_1b check status Operation failed
133 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
134 Table Op Msg_type Msg_text
135 test.t1 check status OK
136 test.t1b check status OK
137 test.t1t check status OK
138 test.t1z check status OK
139 test.t5_7 check status Operation failed
140 test.t5_7b check status Operation failed
141 test.t10_1 check status Operation failed
142 test.t10_1b check status Operation failed
143 SELECT COUNT(*) FROM t1;
144 COUNT(*)
145 1
146 SELECT COUNT(*) FROM t1b;
147 COUNT(*)
148 1
149 SELECT COUNT(*) FROM t1t;
150 COUNT(*)
151 1
152 SELECT COUNT(*) FROM t1z;
153 COUNT(*)
154 1
155 SELECT COUNT(*) FROM t5_7;
156 COUNT(*)
157 1
158 SELECT COUNT(*) FROM t5_7b;
159 COUNT(*)
160 1
161 SELECT COUNT(*) FROM t10_1;
162 COUNT(*)
163 1
164 SELECT COUNT(*) FROM t10_1b;
165 COUNT(*)
166 1
167 # restart
168 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
169 Table Op Msg_type Msg_text
170 test.t1 check status OK
171 test.t1b check status OK
172 test.t1t check status OK
173 test.t1z check status OK
174 test.t5_7 check note Auto_increment checked and .frm file version updated
175 test.t5_7 check status OK
176 test.t5_7b check note Auto_increment checked and .frm file version updated
177 test.t5_7b check status OK
178 test.t10_1 check note Auto_increment checked and .frm file version updated
179 test.t10_1 check status OK
180 test.t10_1b check note Auto_increment checked and .frm file version updated
181 test.t10_1b check status OK
182 INSERT INTO t1 VALUES(NULL);
183 INSERT INTO t1b VALUES(NULL);
184 INSERT INTO t1t VALUES(NULL);
185 INSERT INTO t1z VALUES(NULL);
186 INSERT INTO t5_7 VALUES(NULL);
187 INSERT INTO t5_7b VALUES(NULL);
188 INSERT INTO t10_1 VALUES(NULL);
189 INSERT INTO t10_1b VALUES(NULL);
190 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
191 Table Op Msg_type Msg_text
192 test.t1 check status OK
193 test.t1b check status OK
194 test.t1t check status OK
195 test.t1z check status OK
196 test.t5_7 check note Auto_increment checked and .frm file version updated
197 test.t5_7 check status OK
198 test.t5_7b check note Auto_increment checked and .frm file version updated
199 test.t5_7b check status OK
200 test.t10_1 check note Auto_increment checked and .frm file version updated
201 test.t10_1 check status OK
202 test.t10_1b check note Auto_increment checked and .frm file version updated
203 test.t10_1b check status OK
204 SELECT * FROM t1;
205 id
206 4
207 42
208 SELECT * FROM t1b;
209 id
210 3
211 347
212 SELECT * FROM t1t;
213 id
214 123
215 124
216 SELECT * FROM t1z;
217 id
218 42
219 43
220 SELECT * FROM t5_7;
221 id
222 42
223 43
224 SELECT * FROM t5_7b;
225 id
226 3
227 347
228 SELECT * FROM t10_1;
229 id
230 42
231 43
232 SELECT * FROM t10_1b;
233 id
234 3
235 347
236 DROP TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;