Debian Codegraph @

mysql-test/suite/storage_engine/checksum_table.inc

raw
1 #
2 # CHECKSUM TABLE statements for standard CHECKSUM properties.
3 # Live checksums are covered in checksum_table_live.test
4 #
5
6 --disable_warnings
7 DROP TABLE IF EXISTS t1,t2;
8 --enable_warnings
9
10 # For most engines CHECKSUM=0 option will be ignored,
11 # but we are setting it here for those which have it 1 by default
12 # (there will be another test for live checksum)
13
14 --let $table_options = CHECKSUM=0
15 --let $create_definition = a $int_col, b $char_col
16 --source create_table.inc
17 INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b');
18
19 --let $table_name = t2
20 --let $table_options = CHECKSUM=0
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
31