Files
percona-toolkit/t/pt-variable-advisor/show_variables_static.t
Sveta Smirnova c3f327d53b PT-2340 - Support MySQL 8.4
- Updated tests for pt-variable-advisor and lib/VariableAdvisorRules
2024-09-05 16:45:45 +03:00

84 lines
2.3 KiB
Perl

#!/usr/bin/env perl
BEGIN {
die "The PERCONA_TOOLKIT_BRANCH environment variable is not set.\n"
unless $ENV{PERCONA_TOOLKIT_BRANCH} && -d $ENV{PERCONA_TOOLKIT_BRANCH};
unshift @INC, "$ENV{PERCONA_TOOLKIT_BRANCH}/lib";
};
use strict;
use warnings FATAL => 'all';
use English qw(-no_match_vars);
use Test::More;
use PerconaTest;
require "$trunk/bin/pt-variable-advisor";
# #############################################################################
# SHOW VARIABLES from text files.
# #############################################################################
my @args = qw();
my $sample = "$trunk/t/lib/samples/show-variables/";
ok(
no_diff(
sub { pt_variable_advisor::main(@args,
qw(--source-of-variables), "$sample/vars001.txt") },
"t/pt-variable-advisor/samples/vars001.txt",
),
"vars001.txt"
) or diag($test_diff);
ok(
no_diff(
sub { pt_variable_advisor::main(@args,
qw(--source-of-variables), "$sample/vars002.txt") },
"t/pt-variable-advisor/samples/vars002.txt",
),
"vars002.txt"
) or diag($test_diff);
ok(
no_diff(
sub { pt_variable_advisor::main(@args,
qw(-v --source-of-variables), "$sample/vars001.txt") },
"t/pt-variable-advisor/samples/vars001-verbose.txt",
),
"vars001.txt --verbose"
) or diag($test_diff);
ok(
no_diff(
sub { pt_variable_advisor::main(@args,
qw(-v -v --source-of-variables), "$sample/vars001.txt") },
"t/pt-variable-advisor/samples/vars001-verbose-verbose.txt",
),
"vars001.txt --verbose --verbose"
) or diag($test_diff);
ok(
no_diff(
sub { pt_variable_advisor::main(@args,
qw(--source-of-variables), "$sample/vars001.txt",
qw(--ignore-rules), "sync_binlog,myisam_recover_options") },
"t/pt-variable-advisor/samples/vars001-ignore-rules.txt",
),
"--ignore-rules"
) or diag($test_diff);
my ($output) = full_output(sub {
pt_variable_advisor::main(@args,
'--source-of-variables', "$sample/vars-baron-002.txt"
)});
like(
$output,
qr/\Qdual-source or ring replication configuration?\E$/sm,
"Sentences are delimited by . or ?"
);
# #############################################################################
# Done.
# #############################################################################
done_testing;