Debian Codegraph @

mysql-test/suite/innodb/include/default_row_format_large.inc

raw
1 perl;
2 use strict;
3 use warnings;
4 my $dest_dir = $ENV{'MYSQLTEST_VARDIR'};
5 my $prefix_len = $ENV{'PREFIX_LEN'};
6 open(DATA, ">$dest_dir/tmp/create_table.sql") or die "Couldn't open file
7 $dest_dir/tmp/create_table.sql, $!";
8 print DATA "CREATE TABLE t1(";
9 my $huge_cols = 196;
10 for (my $i=1; $i <= $huge_cols; $i++) {
11 print DATA "c$i TEXT ";
12
13 if ($i != $huge_cols) {
14 print DATA ", ";
15 }
16 }
17
18 print DATA ", ";
19 my $max_keys = 64;
20 for (my $i=1; $i <= $max_keys; $i++) {
21 print DATA "KEY k$i(c$i($prefix_len))";
22
23 if ($i != $max_keys) {
24 print DATA ", ";
25 }
26 }
27
28 print DATA ")ENGINE=INNODB ROW_FORMAT=DYNAMIC charset latin1;";
29 print DATA "\n";
30
31 print DATA "INSERT INTO t1 VALUES (";
32 for (my $i=1; $i <= $huge_cols; $i++) {
33 print DATA "$i$i";
34 if ($i != $huge_cols) {
35 print DATA ", ";
36 }
37 }
38 print DATA ");";
39 print DATA "\n";
40
41 print DATA "UPDATE t1 SET ";
42 for (my $i=1; $i <= $huge_cols; $i++) {
43 print DATA " c$i=REPEAT('a', 1)";
44 if ($i != $huge_cols) {
45 print DATA ", ";
46 }
47 }
48 print DATA ";";
49 print DATA "\n";
50
51 print DATA "UPDATE t1 SET ";
52 for (my $i=1; $i <= $huge_cols; $i++) {
53 print DATA " c$i=REPEAT('a', $i)";
54 if ($i != $huge_cols) {
55 print DATA ", ";
56 }
57 }
58 print DATA ";";
59 print DATA "\n";
60
61 close DATA;
62 EOF