2
# Copyright (C) 2005-2006 MySQL AB
4
# This program is free software; you can redistribute it and/or modify
5
# it under the terms of the GNU General Public License as published by
6
# the Free Software Foundation; version 2 of the License.
8
# This program is distributed in the hope that it will be useful,
9
# but WITHOUT ANY WARRANTY; without even the implied warranty of
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11
# GNU General Public License for more details.
13
# You should have received a copy of the GNU General Public License
14
# along with this program; if not, write to the Free Software
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
17
# This is a library file used by the Perl version of mysql-test-run,
18
# and is part of the translation of the Bourne shell script with the
27
sub collect_test_cases ($);
28
sub collect_one_suite ($);
29
sub collect_one_test_case ($$$$$$$$$);
31
sub mtr_options_from_test_file($$);
37
my ($from, $what)= @_;
38
if ( $from =~ /^[a-z0-9]$/ ) {
39
# Does not contain any regex, make the pattern match
43
# Check that pattern is a valid regex
44
eval { "" =~/$from/; 1 } or
45
mtr_error("Invalid regex '$from' passed to $what\nPerl says: $@");
51
##############################################################################
53
# Collect information about test cases we are to run
55
##############################################################################
57
sub collect_test_cases ($) {
58
$do_test= init_pattern($::opt_do_test, "--do-test");
59
$skip_test= init_pattern($::opt_skip_test, "--skip-test");
61
my $suites= shift; # Semicolon separated list of test suites
62
my $cases = []; # Array of hash
64
foreach my $suite (split(",", $suites))
66
push(@$cases, collect_one_suite($suite));
72
# Check that the tests specified was found
73
# in at least one suite
74
foreach my $test_name_spec ( @::opt_cases )
77
my ($sname, $tname, $extension)= split_testname($test_name_spec);
78
foreach my $test ( @$cases )
80
# test->{name} is always in suite.name format
81
if ( $test->{name} =~ /.*\.$tname/ )
88
mtr_error("Could not find $tname in any suite");
95
# Reorder the test cases in an order that will make them faster to run
98
# Make a mapping of test name to a string that represents how that test
99
# should be sorted among the other tests. Put the most important criterion
100
# first, then a sub-criterion, then sub-sub-criterion, et c.
101
foreach my $tinfo (@$cases)
105
# Look for tests that muct be in run in a defined order
106
# that is defined by test having the same name except for
109
# Put variables into hash
110
my $test_name= $tinfo->{'name'};
111
my $depend_on_test_name;
112
if ( $test_name =~ /^([\D]+)([0-9]{1})$/ )
116
mtr_verbose("$test_name => $base_name idx=$idx");
120
$base_name= "$base_name$idx";
121
mtr_verbose("New basename $base_name");
124
foreach my $tinfo2 (@$cases)
126
if ( $tinfo2->{'name'} eq $base_name )
128
mtr_verbose("found dependent test $tinfo2->{'name'}");
129
$depend_on_test_name=$base_name;
134
if ( defined $depend_on_test_name )
136
mtr_verbose("Giving $test_name same critera as $depend_on_test_name");
137
$sort_criteria{$test_name} = $sort_criteria{$depend_on_test_name};
142
# Append the criteria for sorting, in order of importance.
144
push(@criteria, "ndb=" . ($tinfo->{'ndb_test'} ? "1" : "0"));
145
# Group test with equal options together.
146
# Ending with "~" makes empty sort later than filled
147
push(@criteria, join("!", sort @{$tinfo->{'master_opt'}}) . "~");
149
$sort_criteria{$test_name} = join(" ", @criteria);
154
$sort_criteria{$a->{'name'}} . $a->{'name'} cmp
155
$sort_criteria{$b->{'name'}} . $b->{'name'}; } @$cases;
157
if ( $::opt_script_debug )
159
# For debugging the sort-order
160
foreach my $tinfo (@$cases)
162
print("$sort_criteria{$tinfo->{'name'}} -> \t$tinfo->{'name'}\n");
171
# Valid extensions and their corresonding component id
172
my %exts = ( 'test' => 'mysqld',
177
# Returns (suitename, testname, extension)
181
# Get rid of directory part and split name on .'s
182
my @parts= split(/\./, basename($test_name));
185
# Only testname given, ex: alias
186
return (undef , $parts[0], undef);
187
} elsif (@parts == 2) {
188
# Either testname.test or suite.testname given
189
# Ex. main.alias or alias.test
191
if (defined $exts{$parts[1]})
193
return (undef , $parts[0], $parts[1]);
197
return ($parts[0], $parts[1], undef);
200
} elsif (@parts == 3) {
201
# Fully specified suitename.testname.test
203
return ( $parts[0], $parts[1], $parts[2]);
206
mtr_error("Illegal format of test name: $test_name");
210
sub collect_one_suite($)
212
my $suite= shift; # Test suite name
213
my @cases; # Array of hash
215
mtr_verbose("Collecting: $suite");
217
my $suitedir= "$::glob_mysql_test_dir"; # Default
218
if ( $suite ne "main" )
220
$suitedir= mtr_path_exists("$suitedir/suite/$suite",
222
mtr_verbose("suitedir: $suitedir");
225
my $testdir= "$suitedir/t";
226
my $resdir= "$suitedir/r";
228
# ----------------------------------------------------------------------
229
# Build a hash of disabled testcases for this suite
230
# ----------------------------------------------------------------------
232
if ( open(DISABLED, "$testdir/disabled.def" ) )
237
if ( /^\s*(\S+)\s*:\s*(.*?)\s*$/ )
245
# Read suite.opt file
246
my $suite_opt_file= "$testdir/suite.opt";
248
if ( -f $suite_opt_file )
250
$suite_opts= mtr_get_opts_from_file($suite_opt_file);
255
# Collect in specified order
256
foreach my $test_name_spec ( @::opt_cases )
258
my ($sname, $tname, $extension)= split_testname($test_name_spec);
260
# The test name parts have now been defined
261
#print " suite_name: $sname\n";
262
#print " tname: $tname\n";
263
#print " extension: $extension\n";
265
# Check cirrect suite if suitename is defined
266
next if (defined $sname and $suite ne $sname);
269
if ( defined $extension )
271
my $full_name= "$testdir/$tname.$extension";
272
# Extension was specified, check if the test exists
273
if ( ! -f $full_name)
275
# This is only an error if suite was specified, otherwise it
276
# could exist in another suite
277
mtr_error("Test '$full_name' was not found in suite '$sname'")
282
$component_id= $exts{$extension};
286
# No extension was specified
287
my ($ext, $component);
288
while (($ext, $component)= each %exts) {
289
my $full_name= "$testdir/$tname.$ext";
291
if ( ! -f $full_name ) {
294
$component_id= $component;
297
# Test not found here, could exist in other suite
298
next unless $component_id;
301
collect_one_test_case($testdir,$resdir,$suite,$tname,
302
"$tname.$extension",\@cases,\%disabled,
303
$component_id,$suite_opts);
308
opendir(TESTDIR, $testdir) or mtr_error("Can't open dir \"$testdir\": $!");
310
foreach my $elem ( sort readdir(TESTDIR) )
312
my $component_id= undef;
315
if ($tname= mtr_match_extension($elem, 'test'))
317
$component_id = 'mysqld';
319
elsif ($tname= mtr_match_extension($elem, 'imtest'))
321
$component_id = 'im';
328
# Skip tests that does not match the --do-test= filter
329
next if ($do_test and not $tname =~ /$do_test/o);
331
collect_one_test_case($testdir,$resdir,$suite,$tname,
332
$elem,\@cases,\%disabled,$component_id,
339
# Return empty list if no testcases found
340
return if (@cases == 0);
342
# ----------------------------------------------------------------------
343
# Read combinations for this suite and build testcases x combinations
344
# if any combinations exists
345
# ----------------------------------------------------------------------
346
if ( ! $::opt_skip_combination )
349
my $combination_file= "$suitedir/combinations";
350
#print "combination_file: $combination_file\n";
351
if (@::opt_combinations)
353
# take the combination from command-line
354
mtr_verbose("Take the combination from command line");
355
foreach my $combination (@::opt_combinations) {
357
$comb->{name}= $combination;
358
push(@{$comb->{comb_opt}}, $combination);
359
push(@combinations, $comb);
362
elsif (-f $combination_file )
364
# Read combinations file in my.cnf format
365
mtr_verbose("Read combinations file");
366
my $config= My::Config->new($combination_file);
368
foreach my $group ($config->groups()) {
370
$comb->{name}= $group->name();
371
foreach my $option ( $group->options() ) {
372
push(@{$comb->{comb_opt}}, "--".$option->name()."=".$option->value());
374
push(@combinations, $comb);
380
print " - adding combinations\n";
381
#print_testcases(@cases);
384
foreach my $comb (@combinations)
386
foreach my $test (@cases)
388
#print $test->{name}, " ", $comb, "\n";
391
while (my ($key, $value) = each(%$test)) {
392
if (ref $value eq "ARRAY") {
393
push(@{$new_test->{$key}}, @$value);
395
$new_test->{$key}= $value;
399
# Append the combination options to master_opt and slave_opt
400
push(@{$new_test->{master_opt}}, @{$comb->{comb_opt}});
401
push(@{$new_test->{slave_opt}}, @{$comb->{comb_opt}});
403
# Add combination name shrt name
404
$new_test->{combination}= $comb->{name};
406
# Add the new test to new test cases list
407
push(@new_cases, $new_test);
410
#print_testcases(@new_cases);
412
#print_testcases(@cases);
416
optimize_cases(\@cases);
417
#print_testcases(@cases);
424
# Loop through all test cases
425
# - optimize which test to run by skipping unnecessary ones
426
# - update settings if necessary
431
foreach my $tinfo ( @$cases )
433
# Skip processing if already marked as skipped
434
next if $tinfo->{skip};
436
# =======================================================
437
# If a special binlog format was selected with
438
# --mysqld=--binlog-format=x, skip all test that does not
440
# =======================================================
441
#print "used_binlog_format: $::used_binlog_format\n";
442
if (defined $::used_binlog_format )
444
# =======================================================
445
# Fixed --binlog-format=x specified on command line
446
# =======================================================
447
if ( defined $tinfo->{'binlog_formats'} )
449
#print "binlog_formats: ". join(", ", @{$tinfo->{binlog_formats}})."\n";
451
# The test supports different binlog formats
452
# check if the selected one is ok
454
grep { $_ eq $::used_binlog_format } @{$tinfo->{'binlog_formats'}};
459
"Doesn't support --binlog-format='$::used_binlog_format'";
465
# =======================================================
466
# Use dynamic switching of binlog format
467
# =======================================================
469
# Get binlog-format used by this test from master_opt
470
my $test_binlog_format;
471
foreach my $opt ( @{$tinfo->{master_opt}} ) {
473
mtr_match_prefix($opt, "--binlog-format=") || $test_binlog_format;
476
if (defined $test_binlog_format and
477
defined $tinfo->{binlog_formats} )
480
grep { $_ eq $test_binlog_format } @{$tinfo->{'binlog_formats'}};
485
"Doesn't support --binlog-format='$test_binlog_format'";
495
##############################################################################
497
# Collect information about a single test case
499
##############################################################################
502
sub collect_one_test_case($$$$$$$$$) {
510
my $component_id= shift;
511
my $suite_opts= shift;
513
my $path= "$testdir/$elem";
515
# ----------------------------------------------------------------------
516
# Skip some tests silently
517
# ----------------------------------------------------------------------
519
if ( $::opt_start_from and $tname lt $::opt_start_from )
526
$tinfo->{'name'}= basename($suite) . ".$tname";
527
$tinfo->{'result_file'}= "$resdir/$tname.result";
528
$tinfo->{'component_id'} = $component_id;
529
push(@$cases, $tinfo);
531
# ----------------------------------------------------------------------
532
# Skip some tests but include in list, just mark them to skip
533
# ----------------------------------------------------------------------
535
if ( $skip_test and $tname =~ /$skip_test/o )
541
# ----------------------------------------------------------------------
542
# Collect information about test case
543
# ----------------------------------------------------------------------
545
$tinfo->{'path'}= $path;
546
$tinfo->{'timezone'}= "GMT-3"; # for UNIX_TIMESTAMP tests to work
548
$tinfo->{'slave_num'}= 0; # Default, no slave
549
$tinfo->{'master_num'}= 1; # Default, 1 master
550
if ( defined mtr_match_prefix($tname,"rpl") )
552
if ( $::opt_skip_rpl )
555
$tinfo->{'comment'}= "No replication tests(--skip-rpl)";
559
$tinfo->{'slave_num'}= 1; # Default for rpl* tests, use one slave
563
if ( defined mtr_match_prefix($tname,"federated") )
565
# Default, federated uses the first slave as it's federated database
566
$tinfo->{'slave_num'}= 1;
569
my $master_opt_file= "$testdir/$tname-master.opt";
570
my $slave_opt_file= "$testdir/$tname-slave.opt";
571
my $slave_mi_file= "$testdir/$tname.slave-mi";
572
my $master_sh= "$testdir/$tname-master.sh";
573
my $slave_sh= "$testdir/$tname-slave.sh";
574
my $disabled_file= "$testdir/$tname.disabled";
575
my $im_opt_file= "$testdir/$tname-im.opt";
577
$tinfo->{'master_opt'}= [];
578
$tinfo->{'slave_opt'}= [];
579
$tinfo->{'slave_mi'}= [];
583
foreach my $opt ( @$suite_opts )
586
push(@{$tinfo->{'master_opt'}}, $opt);
587
push(@{$tinfo->{'slave_opt'}}, $opt);
591
if ( -f $master_opt_file )
594
my $master_opt= mtr_get_opts_from_file($master_opt_file);
596
foreach my $opt ( @$master_opt )
600
# The opt file is used both to send special options to the mysqld
601
# as well as pass special test case specific options to this
604
$value= mtr_match_prefix($opt, "--timezone=");
605
if ( defined $value )
607
$tinfo->{'timezone'}= $value;
611
$value= mtr_match_prefix($opt, "--slave-num=");
612
if ( defined $value )
614
$tinfo->{'slave_num'}= $value;
618
$value= mtr_match_prefix($opt, "--result-file=");
619
if ( defined $value )
621
# Specifies the file mysqltest should compare
623
$tinfo->{'result_file'}= "r/$value.result";
627
# If we set default time zone, remove the one we have
628
$value= mtr_match_prefix($opt, "--default-time-zone=");
629
if ( defined $value )
631
# Set timezone for this test case to something different
632
$tinfo->{'timezone'}= "GMT-8";
633
# Fallthrough, add the --default-time-zone option
636
# The --restart option forces a restart even if no special
637
# option is set. If the options are the same as next testcase
638
# there is no need to restart after the testcase
640
if ( $opt eq "--force-restart" )
642
$tinfo->{'force_restart'}= 1;
646
# Ok, this was a real option, add it
647
push(@{$tinfo->{'master_opt'}}, $opt);
652
if ( -f $slave_opt_file )
654
my $slave_opt= mtr_get_opts_from_file($slave_opt_file);
656
foreach my $opt ( @$slave_opt )
658
# If we set default time zone, remove the one we have
659
my $value= mtr_match_prefix($opt, "--default-time-zone=");
660
$tinfo->{'slave_opt'}= [] if defined $value;
662
push(@{$tinfo->{'slave_opt'}}, @$slave_opt);
665
if ( -f $slave_mi_file )
667
$tinfo->{'slave_mi'}= mtr_get_opts_from_file($slave_mi_file);
672
if ( $::glob_win32_perl )
675
$tinfo->{'comment'}= "No tests with sh scripts on Windows";
680
$tinfo->{'master_sh'}= $master_sh;
686
if ( $::glob_win32_perl )
689
$tinfo->{'comment'}= "No tests with sh scripts on Windows";
694
$tinfo->{'slave_sh'}= $slave_sh;
698
if ( -f $im_opt_file )
700
$tinfo->{'im_opts'} = mtr_get_opts_from_file($im_opt_file);
704
$tinfo->{'im_opts'} = [];
707
# FIXME why this late?
708
my $marked_as_disabled= 0;
709
if ( $disabled->{$tname} )
711
$marked_as_disabled= 1;
712
$tinfo->{'comment'}= $disabled->{$tname};
715
if ( -f $disabled_file )
717
$marked_as_disabled= 1;
718
$tinfo->{'comment'}= mtr_fromfile($disabled_file);
721
# If test was marked as disabled, either opt_enable_disabled is off and then
722
# we skip this test, or it is on and then we run this test but warn
724
if ( $marked_as_disabled )
726
if ( $::opt_enable_disabled )
728
$tinfo->{'dont_skip_though_disabled'}= 1;
733
$tinfo->{'disable'}= 1; # Sub type of 'skip'
738
if ( $component_id eq 'im' )
740
if ( $::glob_use_embedded_server )
743
$tinfo->{'comment'}= "No IM with embedded server";
746
elsif ( $::opt_ps_protocol )
749
$tinfo->{'comment'}= "No IM with --ps-protocol";
752
elsif ( $::opt_skip_im )
755
$tinfo->{'comment'}= "No IM tests(--skip-im)";
761
mtr_options_from_test_file($tinfo,"$testdir/${tname}.test");
763
if ( defined $::used_default_engine )
765
# Different default engine is used
766
# tag test to require that engine
767
$tinfo->{'ndb_test'}= 1
768
if ( $::used_default_engine =~ /^ndb/i );
770
$tinfo->{'innodb_test'}= 1
771
if ( $::used_default_engine =~ /^innodb/i );
774
#enable federated for this test
775
if ($tinfo->{'federated_test'})
777
push(@{$tinfo->{'master_opt'}}, "--loose-federated");
778
push(@{$tinfo->{'slave_opt'}}, "--loose-federated");
781
if ( $tinfo->{'big_test'} and ! $::opt_big_test )
784
$tinfo->{'comment'}= "Test need 'big-test' option";
788
if ( $tinfo->{'ndb_extra'} and ! $::opt_ndb_extra_test )
791
$tinfo->{'comment'}= "Test need 'ndb_extra' option";
795
if ( $tinfo->{'require_manager'} )
798
$tinfo->{'comment'}= "Test need the _old_ manager(to be removed)";
802
if ( $tinfo->{'need_debug'} && ! $::debug_compiled_binaries )
805
$tinfo->{'comment'}= "Test need debug binaries";
809
if ( $tinfo->{'ndb_test'} )
812
if ( ! $::glob_ndbcluster_supported )
814
# Ndb is not supported, skip it
816
$tinfo->{'comment'}= "No ndbcluster support";
819
elsif ( $::opt_skip_ndbcluster )
821
# All ndb test's should be skipped
823
$tinfo->{'comment'}= "No ndbcluster tests(--skip-ndbcluster)";
826
# Ndb tests run with two mysqld masters
827
$tinfo->{'master_num'}= 2;
831
# This is not a ndb test
832
if ( $::opt_with_ndbcluster_only )
834
# Only the ndb test should be run, all other should be skipped
836
$tinfo->{'comment'}= "Only ndbcluster tests(--with-ndbcluster-only)";
841
if ( $tinfo->{'innodb_test'} )
843
# This is a test that need innodb
844
if ( $::mysqld_variables{'innodb'} ne "TRUE" )
846
# innodb is not supported, skip it
848
$tinfo->{'comment'}= "No innodb support";
853
if ( $tinfo->{'need_binlog'} )
855
if (grep(/^--skip-log-bin/, @::opt_extra_mysqld_opt) )
858
$tinfo->{'comment'}= "Test need binlog";
864
if ( $::mysql_version_id >= 50100 )
866
# Test does not need binlog, add --skip-binlog to
867
# the options used when starting it
868
push(@{$tinfo->{'master_opt'}}, "--skip-log-bin");
876
# List of tags in the .test files that if found should set
877
# the specified value in "tinfo"
881
["include/have_binlog_format_row.inc", "binlog_formats", ["row"]],
882
["include/have_binlog_format_statement.inc", "binlog_formats", ["statement"]],
883
["include/have_binlog_format_mixed.inc", "binlog_formats", ["mixed"]],
884
["include/have_binlog_format_mixed_or_row.inc",
885
"binlog_formats", ["mixed", "row"]],
886
["include/have_binlog_format_mixed_or_statement.inc",
887
"binlog_formats", ["mixed", "statement"]],
888
["include/have_binlog_format_row_or_statement.inc",
889
"binlog_formats", ["row", "statement"]],
891
["include/have_innodb.inc", "innodb_test", 1],
892
["include/have_log_bin.inc", "need_binlog", 1],
893
["include/big_test.inc", "big_test", 1],
894
["include/have_debug.inc", "need_debug", 1],
895
["include/have_ndb.inc", "ndb_test", 1],
896
["include/have_multi_ndb.inc", "ndb_test", 1],
897
["include/have_ndb_extra.inc", "ndb_extra", 1],
898
["include/ndb_master-slave.inc", "ndb_test", 1],
899
["require_manager", "require_manager", 1],
900
["include/federated.inc", "federated_test", 1],
901
["include/have_federated_db.inc", "federated_test", 1],
904
sub mtr_options_from_test_file($$) {
907
#mtr_verbose("$file");
908
my $F= IO::File->new($file) or mtr_error("can't open file \"$file\": $!");
910
while ( my $line= <$F> )
913
# Skip line if it start's with #
914
next if ( $line =~ /^#/ );
916
# Match this line against tag in "tags" array
917
foreach my $tag (@tags)
919
if ( index($line, $tag->[0]) >= 0 )
921
# Tag matched, assign value to "tinfo"
922
$tinfo->{"$tag->[1]"}= $tag->[2];
926
# If test sources another file, open it as well
927
if ( $line =~ /^\-\-([[:space:]]*)source(.*)$/ or
928
$line =~ /^([[:space:]]*)source(.*);$/ )
931
$value =~ s/^\s+//; # Remove leading space
932
$value =~ s/[[:space:]]+$//; # Remove ending space
934
my $sourced_file= "$::glob_mysql_test_dir/$value";
935
if ( -f $sourced_file )
937
# Only source the file if it exists, we may get
938
# false positives in the regexes above if someone
939
# writes "source nnnn;" in a test case(such as mysqltest.test)
940
mtr_options_from_test_file($tinfo, $sourced_file);
947
sub print_testcases {
950
print "=" x 60, "\n";
951
foreach my $test (@cases){
952
print "[", $test->{name}, "]", "\n";
953
while ((my ($key, $value)) = each(%$test)) {
954
print " ", $key, "=";
955
if (ref $value eq "ARRAY") {
956
print join(", ", @$value);
964
print "=" x 60, "\n";
added
removed
mysql-test/lib/v1/mtr_cases.pl
