Debian Codegraph @

mysql-test/suite/storage_engine/parts/checksum_table.result

raw
1 DROP TABLE IF EXISTS t1,t2;
2 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> CHECKSUM=0 PARTITION BY HASH(a) PARTITIONS 2;
3 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
4 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> CHECKSUM=0 PARTITION BY HASH(a) PARTITIONS 2;
5 CHECKSUM TABLE t1;
6 Table Checksum
7 test.t1 4272806499
8 CHECKSUM TABLE t2, t1;
9 Table Checksum
10 test.t2 0
11 test.t1 4272806499
12 CHECKSUM TABLE t1, t2 QUICK;
13 Table Checksum
14 test.t1 NULL
15 test.t2 NULL
16 CHECKSUM TABLE t1, t2 EXTENDED;
17 Table Checksum
18 test.t1 4272806499
19 test.t2 0
20 DROP TABLE t1, t2;
21 DROP TABLE IF EXISTS t1,t2;
22 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> CHECKSUM=1 PARTITION BY HASH(a) PARTITIONS 2;
23 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
24 CREATE TABLE t2 (a <INT_COLUMN>, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS> CHECKSUM=1 PARTITION BY HASH(a) PARTITIONS 2;
25 CHECKSUM TABLE t1;
26 Table Checksum
27 test.t1 4272806499
28 CHECKSUM TABLE t2, t1;
29 Table Checksum
30 test.t2 0
31 test.t1 4272806499
32 CHECKSUM TABLE t1, t2 QUICK;
33 Table Checksum
34 test.t1 4272806499
35 test.t2 0
36 CHECKSUM TABLE t1, t2 EXTENDED;
37 Table Checksum
38 test.t1 4272806499
39 test.t2 0
40 DROP TABLE t1, t2;