88 lines
2.2 KiB
Plaintext
88 lines
2.2 KiB
Plaintext
DROP TABLE IF EXISTS t1,t2;
|
|
CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=xengine CHECKSUM=0 charset=latin1 collate latin1_bin;
|
|
INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
|
|
CREATE TABLE t2 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=xengine CHECKSUM=0 charset=latin1 collate latin1_bin;
|
|
CHECKSUM TABLE t1;
|
|
Table Checksum
|
|
test.t1 4259194219
|
|
CHECKSUM TABLE t2, t1;
|
|
Table Checksum
|
|
test.t2 0
|
|
test.t1 4259194219
|
|
CHECKSUM TABLE t1, t2 QUICK;
|
|
Table Checksum
|
|
test.t1 NULL
|
|
test.t2 NULL
|
|
CHECKSUM TABLE t1, t2 EXTENDED;
|
|
Table Checksum
|
|
test.t1 4259194219
|
|
test.t2 0
|
|
DROP TABLE t1, t2;
|
|
#
|
|
# Issue #110: SQL command checksum returns inconsistent result
|
|
#
|
|
create table t1 (pk int primary key, col1 varchar(10)) engine=xengine;
|
|
insert into t1 values (2,'fooo');
|
|
insert into t1 values (1,NULL);
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
select * from t1 where pk=2;
|
|
pk col1
|
|
2 fooo
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
flush tables;
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
drop table t1;
|
|
#
|
|
# The following test is about making sure MyX CHECKSUM TABLE
|
|
# values are the same as with InnoDB.
|
|
# If you see checksum values changed, make sure their counterparts
|
|
# in suite/innodb/r/checksum-matches-myrocks.result match.
|
|
#
|
|
create table t1 (pk int primary key, col1 varchar(10)) engine=xengine;
|
|
insert into t1 values (2,'fooo');
|
|
insert into t1 values (1,NULL);
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 1303411884
|
|
drop table t1;
|
|
create table t1 (
|
|
pk bigint unsigned primary key,
|
|
col1 varchar(10),
|
|
col2 tinyint,
|
|
col3 double
|
|
) engine=xengine;
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 0
|
|
insert into t1 values (1, NULL, NULL, NULL);
|
|
insert into t1 values (2, 'foo', NULL, NULL);
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 3633741545
|
|
insert into t1 values (3, NULL, 123, NULL);
|
|
insert into t1 values (4, NULL, NULL, 2.78);
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 390004011
|
|
insert into t1 values (5, 'xxxYYYzzzT', NULL, 2.78);
|
|
insert into t1 values (6, '', NULL, 2.78);
|
|
checksum table t1;
|
|
Table Checksum
|
|
test.t1 3183101003
|
|
drop table t1;
|