| 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; |