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