Debian Codegraph @

mysql-test/suite/innodb/t/autoinc_import.test

raw
1 --source include/have_innodb.inc
2
3 CREATE TABLE t1 (id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES(42);
5 CREATE TABLE t1b LIKE t1;
6 INSERT INTO t1b VALUES(3);
7 CREATE TABLE t1z LIKE t1;
8 CREATE TABLE t1t (id TINYINT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
9 CREATE TABLE t0t LIKE t1t;
10 INSERT INTO t1t VALUES(123);
11 --let DATADIR=`select @@datadir`
12 --let PAGE_SIZE=`select @@innodb_page_size`
13 FLUSH TABLES t1,t1b,t1t FOR EXPORT;
14 --copy_file $DATADIR/test/t1.ibd $DATADIR/test/t.ibd
15 --copy_file $DATADIR/test/t1.ibd $DATADIR/test/tz.ibd
16 --copy_file $DATADIR/test/t1b.ibd $DATADIR/test/tb.ibd
17 --copy_file $DATADIR/test/t1t.ibd $DATADIR/test/tt.ibd
18 UNLOCK TABLES;
19 CREATE TABLE t5_7 LIKE t1;
20 CREATE TABLE t5_7b LIKE t1b;
21 CREATE TABLE t10_1 LIKE t1;
22 CREATE TABLE t10_1b LIKE t1b;
23 ALTER TABLE t1 DISCARD TABLESPACE;
24 ALTER TABLE t1b DISCARD TABLESPACE;
25 ALTER TABLE t1z DISCARD TABLESPACE;
26 ALTER TABLE t1t DISCARD TABLESPACE;
27 ALTER TABLE t0t DISCARD TABLESPACE;
28 ALTER TABLE t5_7 DISCARD TABLESPACE;
29 ALTER TABLE t5_7b DISCARD TABLESPACE;
30 ALTER TABLE t10_1 DISCARD TABLESPACE;
31 ALTER TABLE t10_1b DISCARD TABLESPACE;
32 FLUSH TABLES;
33
34 # Update the PAGE_ROOT_AUTO_INC field of a few files.
35 perl;
36 do "$ENV{MTR_SUITE_DIR}/include/crc32.pl";
37 sub update_autoinc
38 {
39 my ($file, $value) = @_;
40 open(FILE, "+<$file") || die "Unable to open $file";
41 binmode FILE;
42 my $ps= $ENV{PAGE_SIZE};
43 my $page;
44 die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps;
45 my $full_crc32 = unpack("N",substr($page,54,4)) & 0x10; # FIL_SPACE_FLAGS
46 sysseek(FILE, 3*$ps, 0) || die "Unable to seek $file\n";
47 die "Unable to read $file" unless sysread(FILE, $page, $ps) == $ps;
48 substr($page,56,8)=pack("NN",0,$value);
49 my $polynomial = 0x82f63b78; # CRC-32C
50 if ($full_crc32) {
51 my $ck = mycrc32(substr($page, 0, $ps-4), 0, $polynomial);
52 substr($page, $ps-4, 4) = pack("N", $ck);
53 }
54 else
55 {
56 my $ck= pack("N",mycrc32(substr($page, 4, 22), 0, $polynomial) ^
57 mycrc32(substr($page, 38, $ps - 38 - 8), 0, $polynomial));
58 substr($page,0,4)=$ck;
59 substr($page,$ps-8,4)=$ck;
60 }
61 sysseek(FILE, 3*$ps, 0) || die "Unable to rewind $file\n";
62 syswrite(FILE, $page, $ps)==$ps || die "Unable to write $file\n";
63 close(FILE) || die "Unable to close $file";
64 }
65 update_autoinc("$ENV{DATADIR}/test/tz.ibd", 0);
66 update_autoinc("$ENV{DATADIR}/test/t.ibd", 3);
67 update_autoinc("$ENV{DATADIR}/test/tb.ibd", 346);
68 update_autoinc("$ENV{DATADIR}/test/tt.ibd", 128);
69 EOF
70
71 --remove_file $DATADIR/test/t5_7.frm
72 --remove_file $DATADIR/test/t5_7b.frm
73 --copy_file $MYSQL_TEST_DIR/std_data/autoinc_import_57.frm $DATADIR/test/t5_7.frm
74 --copy_file $MYSQL_TEST_DIR/std_data/autoinc_import_57.frm $DATADIR/test/t5_7b.frm
75 --remove_file $DATADIR/test/t10_1.frm
76 --remove_file $DATADIR/test/t10_1b.frm
77 --copy_file $MYSQL_TEST_DIR/std_data/autoinc_import_101.frm $DATADIR/test/t10_1.frm
78 --copy_file $MYSQL_TEST_DIR/std_data/autoinc_import_101.frm $DATADIR/test/t10_1b.frm
79 --copy_file $DATADIR/test/t.ibd $DATADIR/test/t5_7.ibd
80 --copy_file $DATADIR/test/tb.ibd $DATADIR/test/t5_7b.ibd
81 --copy_file $DATADIR/test/t.ibd $DATADIR/test/t10_1.ibd
82 --copy_file $DATADIR/test/tb.ibd $DATADIR/test/t10_1b.ibd
83 --move_file $DATADIR/test/t.ibd $DATADIR/test/t1.ibd
84 --move_file $DATADIR/test/tb.ibd $DATADIR/test/t1b.ibd
85 --copy_file $DATADIR/test/tt.ibd $DATADIR/test/t0t.ibd
86 --move_file $DATADIR/test/tt.ibd $DATADIR/test/t1t.ibd
87 --move_file $DATADIR/test/tz.ibd $DATADIR/test/t1z.ibd
88
89 ALTER TABLE t0t IMPORT TABLESPACE;
90 INSERT INTO t0t VALUES(NULL);
91 SELECT * FROM t0t;
92 DROP TABLE t0t;
93 ALTER TABLE t1 IMPORT TABLESPACE;
94 ALTER TABLE t1b IMPORT TABLESPACE;
95 ALTER TABLE t1z IMPORT TABLESPACE;
96 ALTER TABLE t1t IMPORT TABLESPACE;
97 ALTER TABLE t5_7 IMPORT TABLESPACE;
98 ALTER TABLE t5_7b IMPORT TABLESPACE;
99 ALTER TABLE t10_1 IMPORT TABLESPACE;
100 ALTER TABLE t10_1b IMPORT TABLESPACE;
101
102 --let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err
103 --let SEARCH_PATTERN= InnoDB: Resetting PAGE_ROOT_AUTO_INC from 128 to 123 on table `test`\.`t0t`
104 --source include/search_pattern_in_file.inc
105 --let SEARCH_PATTERN= InnoDB: Resetting PAGE_ROOT_AUTO_INC from 0 to 42 on table `test`\.`t1z`
106 --source include/search_pattern_in_file.inc
107 --let SEARCH_PATTERN= InnoDB: Resetting PAGE_ROOT_AUTO_INC from 128 to 123 on table `test`\.`t1t`
108 --source include/search_pattern_in_file.inc
109 --let SEARCH_PATTERN= InnoDB: Resetting PAGE_ROOT_AUTO_INC from 3 to 42 on table `test`\.`t5_7` \(created with version 50744\)
110 --source include/search_pattern_in_file.inc
111 --let SEARCH_PATTERN= InnoDB: Resetting PAGE_ROOT_AUTO_INC from 3 to 42 on table `test`\.`t10_1` \(created with version 100149\)
112 --source include/search_pattern_in_file.inc
113 --let SEARCH_PATTERN= InnoDB: Resetting PAGE_ROOT_AUTO_INC
114 --source include/search_pattern_in_file.inc
115
116 # Restart, so that the InnoDB tables will be loaded into the data dictionary.
117 --let $restart_parameters=--read-only
118 --source include/restart_mysqld.inc
119
120 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;
121 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
122
123 --let $restart_parameters=--innodb-read-only --read-only
124 --source include/restart_mysqld.inc
125
126 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;
127 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
128
129 --let $restart_parameters=--innodb-read-only
130 --source include/restart_mysqld.inc
131
132 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;
133 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
134
135 SELECT COUNT(*) FROM t1;
136 SELECT COUNT(*) FROM t1b;
137 SELECT COUNT(*) FROM t1t;
138 SELECT COUNT(*) FROM t1z;
139 SELECT COUNT(*) FROM t5_7;
140 SELECT COUNT(*) FROM t5_7b;
141 SELECT COUNT(*) FROM t10_1;
142 SELECT COUNT(*) FROM t10_1b;
143
144 --let $restart_parameters=
145 --source include/restart_mysqld.inc
146
147 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
148
149 INSERT INTO t1 VALUES(NULL);
150 INSERT INTO t1b VALUES(NULL);
151 INSERT INTO t1t VALUES(NULL);
152 INSERT INTO t1z VALUES(NULL);
153 INSERT INTO t5_7 VALUES(NULL);
154 INSERT INTO t5_7b VALUES(NULL);
155 INSERT INTO t10_1 VALUES(NULL);
156 INSERT INTO t10_1b VALUES(NULL);
157
158 CHECK TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b FOR UPGRADE;
159
160 SELECT * FROM t1;
161 SELECT * FROM t1b;
162 SELECT * FROM t1t;
163 SELECT * FROM t1z;
164 SELECT * FROM t5_7;
165 SELECT * FROM t5_7b;
166 SELECT * FROM t10_1;
167 SELECT * FROM t10_1b;
168 DROP TABLE t1, t1b, t1t, t1z, t5_7, t5_7b, t10_1, t10_1b;