Debian Codegraph @

mysql-test/suite/storage_engine/checksum_table_live.inc

raw
1 #
2 # CHECKSUM TABLE statements for live CHECKSUM.
3 #
4 # Note: the feature is likely to be unsupported, in which case
5 # instead of numeric values some CHECKSUMs will produce NULL
6 #
7
8 --disable_warnings
9 DROP TABLE IF EXISTS t1,t2;
10 --enable_warnings
11
12 # For most engines CHECKSUM=1 option will be ignored,
13 # and the results will be different
14
15 --let $table_options = CHECKSUM=1
16 --let $create_definition = a $int_col, b $char_col
17 --source create_table.inc
18 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
19 --let $table_name = t2
20 --let $table_options = CHECKSUM=1
21 --let $create_definition = a $int_col, b $char_col
22 --source create_table.inc
23
24 CHECKSUM TABLE t1;
25 CHECKSUM TABLE t2, t1;
26 CHECKSUM TABLE t1, t2 QUICK;
27 CHECKSUM TABLE t1, t2 EXTENDED;
28
29 DROP TABLE t1, t2;
30