| 1 |
# |
| 2 |
# Make sure that files created with --innodb-checksum-algorithm=crc32 |
| 3 |
# on both big and little endian machines are readable. The two .ibd files |
| 4 |
# are precreated in crc32_endianness.zip which is extracted below. |
| 5 |
# |
| 6 |
|
| 7 |
# Since we import a pre-created tablespace with 16k page size, we would get |
| 8 |
# this on InnoDB configured with non-16k page size: |
| 9 |
# ALTER TABLE crc32_big_endian IMPORT TABLESPACE: |
| 10 |
# Schema mismatch (Tablespace to be imported has a different page size than |
| 11 |
# this server. Server page size is 4096, whereas tablespace page size is 16384) |
| 12 |
|
| 13 |
CREATE TABLE crc32_big_endian (a VARCHAR(16)) ENGINE=INNODB charset latin1 |
| 14 |
ROW_FORMAT=COMPACT; |
| 15 |
CREATE TABLE crc32_little_endian (a VARCHAR(16)) ENGINE=INNODB charset latin1 |
| 16 |
ROW_FORMAT=COMPACT; |
| 17 |
|
| 18 |
ALTER TABLE crc32_big_endian DISCARD TABLESPACE; |
| 19 |
ALTER TABLE crc32_little_endian DISCARD TABLESPACE; |
| 20 |
|
| 21 |
-- exec unzip -qo $MYSQL_TEST_DIR/std_data/crc32_endianness.zip -d $MYSQLTEST_VARDIR/tmp/crc32_endianness |
| 22 |
|
| 23 |
-- let DATADIR = `SELECT @@datadir` |
| 24 |
|
| 25 |
-- copy_file $MYSQLTEST_VARDIR/tmp/crc32_endianness/crc32_big_endian.ibd $DATADIR/test/crc32_big_endian.ibd |
| 26 |
-- copy_file $MYSQLTEST_VARDIR/tmp/crc32_endianness/crc32_big_endian.cfg $DATADIR/test/crc32_big_endian.cfg |
| 27 |
-- copy_file $MYSQLTEST_VARDIR/tmp/crc32_endianness/crc32_little_endian.ibd $DATADIR/test/crc32_little_endian.ibd |
| 28 |
-- copy_file $MYSQLTEST_VARDIR/tmp/crc32_endianness/crc32_little_endian.cfg $DATADIR/test/crc32_little_endian.cfg |
| 29 |
|
| 30 |
ALTER TABLE crc32_big_endian IMPORT TABLESPACE; |
| 31 |
ALTER TABLE crc32_little_endian IMPORT TABLESPACE; |
| 32 |
|
| 33 |
SELECT * FROM crc32_big_endian; |
| 34 |
SELECT * FROM crc32_little_endian; |
| 35 |
|
| 36 |
DROP TABLE crc32_big_endian; |
| 37 |
DROP TABLE crc32_little_endian; |
| 38 |
--force-rmdir $MYSQLTEST_VARDIR/tmp/crc32_endianness |