Debian Codegraph @

mysql-test/suite/innodb_zip/t/innochecksum_2.test

raw
1 #************************************************************
2 # WL6045:Improve Innochecksum
3 #************************************************************
4 --source include/innodb_page_size_small.inc
5 --source include/have_debug.inc
6 # Avoid CrashReporter popup on Mac.
7 --source include/not_crashrep.inc
8
9 --source include/not_embedded.inc
10 -- source include/big_test.inc
11
12 let MYSQLD_BASEDIR= `SELECT @@basedir`;
13 let MYSQLD_DATADIR= `SELECT @@datadir`;
14 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/my_restart.err;
15 let $restart_noprint=2;
16
17 SET GLOBAL innodb_compression_level=0;
18 SELECT @@innodb_compression_level;
19
20 CREATE TABLE t1 (j LONGBLOB) ENGINE = InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
21 INSERT INTO t1 VALUES (repeat('abcdefghijklmnopqrstuvwxyz',200));
22 let $i=10;
23 while ($i > 0) {
24 INSERT INTO t1 SELECT * from t1;
25 dec $i;
26 }
27
28 CREATE TABLE t2 (j LONGBLOB) ENGINE = InnoDB
29 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2;
30
31 CREATE TABLE t3 (j LONGBLOB) ENGINE = InnoDB
32 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
33
34 CREATE TABLE t4(c1 INT PRIMARY KEY,c2 VARCHAR(20),
35 INDEX(c2(10))) ENGINE=InnoDB;
36
37 let FLAG= `SELECT flag FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME="test/t1"`;
38
39 let FLAG2= `SELECT flag FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME="test/t2"`;
40
41 let FLAG3= `SELECT flag FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME="test/t3"`;
42
43 let FLAG4= `SELECT flag FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE NAME="test/t4"`;
44
45 --echo # stop the server
46 --source include/shutdown_mysqld.inc
47
48 # Page_type_dump for t1
49 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
50 --exec $INNOCHECKSUM -v --page-type-dump $MYSQLTEST_VARDIR/tmp/dump.txt $MYSQLD_DATADIR/test/t1.ibd
51 --file_exists $MYSQLTEST_VARDIR/tmp/dump.txt
52 --remove_file $MYSQLTEST_VARDIR/tmp/dump.txt
53
54 --echo [1]:# check the both short and long options for "help"
55 --exec $INNOCHECKSUM --help $MYSQLD_DATADIR/test/t1.ibd > $MYSQLTEST_VARDIR/tmp/help_output_long.txt
56 --exec $INNOCHECKSUM -I $MYSQLD_DATADIR/test/t1.ibd > $MYSQLTEST_VARDIR/tmp/help_output_short.txt
57 --diff_files $MYSQLTEST_VARDIR/tmp/help_output_long.txt $MYSQLTEST_VARDIR/tmp/help_output_short.txt
58
59 --echo [2]:# Run the innochecksum when file isn't provided.
60 --echo # It will print the innochecksum usage similar to --help option.
61 --error 1
62 --exec $INNOCHECKSUM > $MYSQLTEST_VARDIR/tmp/usage.txt
63 --diff_files $MYSQLTEST_VARDIR/tmp/help_output_long.txt $MYSQLTEST_VARDIR/tmp/usage.txt
64 --remove_file $MYSQLTEST_VARDIR/tmp/usage.txt
65
66 perl;
67 use strict;
68 use warnings;
69 use File::Copy;
70 my $dir = $ENV{'MYSQLTEST_VARDIR'};
71 my $file= 'help_output_long.txt';
72 # open file in write mode
73 open IN_FILE,"<", "$dir/tmp/$file" or die $!;
74 open OUT_FILE, ">", "$dir/tmp/tmpfile" or die $!;
75 while(<IN_FILE>) {
76 unless ($_=~ /^debug.*$/ || $_=~ /\-#, \-\-debug.*$/ || $_=~ /http:.*html/) {
77 $_=~ s/^\S*innochecksum.* from .+$/innochecksum Ver #.#.#/g;
78 $_=~ s/(Copyright\s\(c\))\s([0-9]*),\s([0-9]*)(.*)/$1 YEAR, YEAR $4/g;
79 $_=~ s/Usage:.*\[-c/Usage: innochecksum [-c/g;
80 print OUT_FILE $_;
81 }
82 }
83 close(IN_FILE);
84 close(OUT_FILE);
85 # move the new content from tmp file to the orginal file.
86 move ("$dir/tmp/tmpfile", "$dir/tmp/$file");
87 EOF
88
89 --cat_file $MYSQLTEST_VARDIR/tmp/help_output_long.txt
90 --remove_file $MYSQLTEST_VARDIR/tmp/help_output_long.txt
91 --remove_file $MYSQLTEST_VARDIR/tmp/help_output_short.txt
92
93 --echo [3]:# check the both short and long options for "count" and exit
94 --replace_regex /[0-9]+/#/
95 --exec $INNOCHECKSUM --count $MYSQLD_DATADIR/test/t1.ibd
96 --replace_regex /[0-9]+/#/
97 --exec $INNOCHECKSUM -c $MYSQLD_DATADIR/test/t1.ibd
98
99 --echo [4]:# Print the version of innochecksum and exit
100 --replace_regex /for \S+/for OS/ /\d+/#/ /#[-_A-Za-z0-9]*-MariaDB,/#-MariaDB,/ /\(.*\)/(ARCH)/ /^.*innochecksum(\.exe)?/innochecksum/
101 --exec $INNOCHECKSUM -V
102
103 --echo [5]:# check t1.ibd and t2.ibd summary with and without tablespace_flags
104 let $resultlog=$MYSQLTEST_VARDIR/tmp/result.log;
105 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t1.ibd -s 3 -e 5 > $resultlog
106 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t2.ibd -s 3 -e 5 > $resultlog
107 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t3.ibd -s 3 -e 5 > $resultlog
108 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t4.ibd -s 3 -e 5 > $resultlog
109
110
111 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t1.ibd --tablespace_flags=$FLAG -s 3 -e 5 > $resultlog
112 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t2.ibd --tablespace_flags=$FLAG2 -s 3 -e 5 > $resultlog
113 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t3.ibd --tablespace_flags=$FLAG3 -s 3 -e 5 > $resultlog
114 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/t4.ibd --tablespace_flags=$FLAG4 -s 3 -e 5 > $resultlog
115
116 remove_file $resultlog;
117 --echo # Restart the DB server
118 --source include/start_mysqld.inc
119
120 DROP TABLE t4, t3, t2, t1;