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
|
use strict;
use warnings;
use DBI;
use Test::More;
use vars qw($test_dsn $test_user $test_password);
use lib 't', '.';
require "lib.pl";
my $dbh;
eval{$dbh = DBI->connect($test_dsn, $test_user, $test_password,
{RaiseError => 1});};
if ($@) {
plan skip_all =>
"no database connection";
}
if ($dbh->{mysql_serverversion} > 100000) {
plan skip_all => "GTID tracking is not available on MariaDB";
}
if ($dbh->{mysql_serverversion} < 50000) {
plan skip_all => "You must have MySQL version 5.0.0 and greater for this test to run";
}
my @gtidtrackenabled = $dbh->selectrow_array('select @@global.session_track_gtids');
if (!@gtidtrackenabled) {
plan skip_all => 'GTID tracking not available';
} elsif ($gtidtrackenabled[0] eq 'OFF') {
plan skip_all => 'GTID tracking not enabled';
} else {
plan tests => 2;
}
$dbh->do('FLUSH PRIVILEGES');
cmp_ok(length($dbh->{'mysql_gtids'}),'>=',38);
ok $dbh->disconnect();
|
