| 1 |
--source suite/innodb/include/checksum_not_strict.inc |
| 2 |
--echo # |
| 3 |
--echo # Bug#19500258 ZERO CAN BE A VALID INNODB CHECKSUM, |
| 4 |
--echo # BUT VALIDATION WILL FAIL LATER |
| 5 |
--echo # |
| 6 |
--let $old_checksum_algorithm= `SELECT @@GLOBAL.innodb_checksum_algorithm` |
| 7 |
SET GLOBAL innodb_checksum_algorithm = 'CRC32'; |
| 8 |
CREATE TABLE t1 (a INT PRIMARY KEY, b VARBINARY(512)) ENGINE=InnoDB; |
| 9 |
INSERT INTO t1 VALUES (1, X'666F72636520637263333220a0be0639'); |
| 10 |
--source include/restart_mysqld.inc |
| 11 |
SELECT count(*) FROM t1; |
| 12 |
--disable_query_log |
| 13 |
--eval SET GLOBAL innodb_checksum_algorithm = '$old_checksum_algorithm' |
| 14 |
--enable_query_log |
| 15 |
drop table t1; |