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