HEX
Server: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.34
System: Linux atalantini.com 3.10.0-1127.13.1.el7.x86_64 #1 SMP Tue Jun 23 15:46:38 UTC 2020 x86_64
User: root (0)
PHP: 7.2.34
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/r/old-mode.result
drop table if exists t1,t2;
create table t1 (a int, b varchar(200), c text not null) checksum=1;
create table t2 (a int, b varchar(200), c text not null) checksum=0;
insert t1 values (1, "aaa", "bbb"), (NULL, "", "ccccc"), (0, NULL, "");
insert t2 select * from t1;
checksum table t1, t2;
Table	Checksum
test.t1	2948697075
test.t2	2948697075
checksum table t1, t2 quick;
Table	Checksum
test.t1	NULL
test.t2	NULL
checksum table t1, t2 extended;
Table	Checksum
test.t1	2948697075
test.t2	2948697075
drop table t1,t2;
SHOW PROCESSLIST;
Id	User	Host	db	Command	Time	State	Info
<Id>	root	<Host>	test	Query	<Time>	NULL	SHOW PROCESSLIST