summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPali <pali@cpan.org>2019-06-07 16:30:27 +0200
committerRobert Bindar <robert@mariadb.org>2019-07-19 13:39:20 +0300
commit5cc2096f93b7f130b36f8bc0fc43440db9a848e4 (patch)
tree48dc24bbde0c7a15181d01b7aea08e43992f4364
parent9a7d96e8326377b92406c09fdcb8bd60c45f901c (diff)
downloadmariadb-git-5cc2096f93b7f130b36f8bc0fc43440db9a848e4.tar.gz
Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driverbb-10.5-MDEV-18565
Perl DBD::MariaDB driver is available CPAN and is already used in production environment.
-rw-r--r--Docs/INSTALL-BINARY2
-rw-r--r--debian/additions/innotop/innotop59
-rw-r--r--debian/additions/innotop/innotop.112
-rwxr-xr-xdebian/additions/mysqlreport6
-rw-r--r--debian/additions/mysqlreport.12
-rw-r--r--debian/control2
-rw-r--r--man/mysql_convert_table_format.12
-rw-r--r--man/mysql_setpermission.12
-rw-r--r--mysql-test/include/have_dbi_dbd-mariadb.inc (renamed from mysql-test/include/have_dbi_dbd-mysql.inc)10
-rw-r--r--mysql-test/include/mysqlhotcopy.inc4
-rwxr-xr-xmysql-test/std_data/checkDBI_DBD-MariaDB.pl (renamed from mysql-test/std_data/checkDBI_DBD-mysql.pl)26
-rwxr-xr-xplugin/handler_socket/client/hspool_test.pl4
-rwxr-xr-xplugin/handler_socket/client/hstest.pl4
-rw-r--r--plugin/handler_socket/regtest/common/hstest.pm8
-rw-r--r--scripts/mysql_convert_table_format.sh4
-rw-r--r--scripts/mysql_setpermission.sh2
-rw-r--r--scripts/mysqlhotcopy.sh8
-rw-r--r--scripts/mytop.sh6
-rw-r--r--sql-bench/server-cfg.sh4
-rw-r--r--storage/maria/ma_ft_test1.h2
-rw-r--r--storage/rocksdb/mysql-test/rocksdb/t/rqg.inc4
-rwxr-xr-xtests/big_record.pl6
-rw-r--r--tests/check_async_queries.pl2
-rwxr-xr-xtests/consistent_snapshot.pl2
-rwxr-xr-xtests/drop_test.pl12
-rwxr-xr-xtests/fork_big.pl28
-rw-r--r--tests/fork_big2.pl32
-rwxr-xr-xtests/grant.pl4
-rwxr-xr-xtests/index_corrupt.pl10
-rwxr-xr-xtests/insert_and_repair.pl10
-rwxr-xr-xtests/mail_to_db.pl6
-rwxr-xr-xtests/pmail.pl2
-rwxr-xr-xtests/rename_test.pl12
-rwxr-xr-xtests/test_delayed_insert.pl22
-rwxr-xr-xtests/truncate.pl6
35 files changed, 161 insertions, 166 deletions
diff --git a/Docs/INSTALL-BINARY b/Docs/INSTALL-BINARY
index 2bd6daaea17..64d5192a49d 100644
--- a/Docs/INSTALL-BINARY
+++ b/Docs/INSTALL-BINARY
@@ -154,7 +154,7 @@ shell> chown -R mysql data
script itself and at
https://mariadb.com/kb/en/starting-and-stopping-mariadb-automatically.
10. You can set up new accounts using the bin/mysql_setpermission
- script if you install the DBI and DBD::mysql Perl modules. See
+ script if you install the DBI and DBD::MariaDB Perl modules. See
Section 4.6.14, "mysql_setpermission --- Interactively Set
Permissions in Grant Tables." For Perl module installation
instructions, see Section 2.15, "Perl Installation Notes."
diff --git a/debian/additions/innotop/innotop b/debian/additions/innotop/innotop
index eb4b3590cf6..0ceb471140c 100644
--- a/debian/additions/innotop/innotop
+++ b/debian/additions/innotop/innotop
@@ -63,7 +63,7 @@ sub new {
},
F => {
desc => 'Only read default options from the given file',
- dsn => 'mysql_read_default_file',
+ dsn => 'mariadb_read_default_file',
copy => 1,
},
h => {
@@ -83,7 +83,7 @@ sub new {
},
S => {
desc => 'Socket file to use for connection',
- dsn => 'mysql_socket',
+ dsn => 'mariadb_socket',
copy => 1,
},
u => {
@@ -218,11 +218,11 @@ sub get_cxn_params {
qw(h P));
}
else {
- $dsn = 'DBI:mysql:' . ( $info->{D} || '' ) . ';'
+ $dsn = 'DBI:MariaDB:' . ( $info->{D} || '' ) . ';'
. join(';', map { "$opts{$_}->{dsn}=$info->{$_}" }
grep { defined $info->{$_} }
qw(F h P S A))
- . ';mysql_read_default_group=client';
+ . ';mariadb_read_default_group=client';
}
MKDEBUG && _d($dsn);
return ($dsn, $info->{u}, $info->{p});
@@ -249,7 +249,6 @@ sub get_dbh {
AutoCommit => 0,
RaiseError => 1,
PrintError => 0,
- mysql_enable_utf8 => ($cxn_string =~ m/charset=utf8/ ? 1 : 0),
};
@{$defaults}{ keys %$opts } = values %$opts;
my $dbh;
@@ -276,10 +275,6 @@ sub get_dbh {
};
if ( !$dbh && $EVAL_ERROR ) {
MKDEBUG && _d($EVAL_ERROR);
- if ( $EVAL_ERROR =~ m/not a compiled character set|character set utf8/ ) {
- MKDEBUG && _d("Going to try again without utf8 support");
- delete $defaults->{mysql_enable_utf8};
- }
if ( !$tries ) {
die $EVAL_ERROR;
}
@@ -301,11 +296,11 @@ sub get_dbh {
$dbh,
Dumper($dbh->selectrow_hashref(
'SELECT DATABASE(), CONNECTION_ID(), VERSION()/*!50038 , @@hostname*/')),
- ' Connection info: ', ($dbh->{mysql_hostinfo} || 'undef'),
+ ' Connection info: ', ($dbh->{mariadb_hostinfo} || 'undef'),
' Character set info: ',
Dumper($dbh->selectall_arrayref(
'SHOW VARIABLES LIKE "character_set%"', { Slice => {}})),
- ' $DBD::mysql::VERSION: ', $DBD::mysql::VERSION,
+ ' $DBD::MariaDB::VERSION: ', $DBD::MariaDB::VERSION,
' $DBI::VERSION: ', $DBI::VERSION,
);
return $dbh;
@@ -314,7 +309,7 @@ sub get_dbh {
# Tries to figure out a hostname for the connection.
sub get_hostname {
my ( $self, $dbh ) = @_;
- if ( my ($host) = ($dbh->{mysql_hostinfo} || '') =~ m/^(\w+) via/ ) {
+ if ( my ($host) = ($dbh->{mariadb_hostinfo} || '') =~ m/^(\w+) via/ ) {
return $host;
}
my ( $hostname, $one ) = $dbh->selectrow_array(
@@ -4534,7 +4529,7 @@ my %stmt_maker_for = (
eval { # This can fail if the table doesn't exist, INFORMATION_SCHEMA doesn't exist, etc.
my $cols = $dbh->selectall_arrayref(q{SHOW /*innotop*/ COLUMNS FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS});
if ( @$cols ) {
- if ($dbh->{mysql_serverinfo} =~ /^5.1/) {
+ if ($dbh->{mariadb_serverinfo} =~ /^5.1/) {
$sth = $dbh->prepare(q{
SELECT /*innotop*/
r.trx_mysql_thread_id AS waiting_thread,
@@ -7259,7 +7254,7 @@ sub create_statusbar {
my $cxn = '';
if ( 1 == @cxns && $dbhs{$cxns[0]} && $dbhs{$cxns[0]}->{dbh} ) {
- $cxn = $dbhs{$cxns[0]}->{dbh}->{mysql_serverinfo} || '';
+ $cxn = $dbhs{$cxns[0]}->{dbh}->{mariadb_serverinfo} || '';
}
else {
if ( $modes{$mode}->{server_group} ) {
@@ -7341,11 +7336,11 @@ sub add_new_dsn {
if ( !$dsn ) {
do {
$clear_screen_sub->();
- print "Typical DSN strings look like\n DBI:mysql:;host=hostname;port=port\n"
+ print "Typical DSN strings look like\n DBI:MariaDB:;host=hostname;port=port\n"
. "The db and port are optional and can usually be omitted.\n"
- . "If you specify 'mysql_read_default_group=mysql' many options can be read\n"
+ . "If you specify 'mariadb_read_default_group=mysql' many options can be read\n"
. "from your mysql options files (~/.my.cnf, /etc/my.cnf).\n\n";
- $dsn = prompt("Enter a DSN string", undef, "DBI:mysql:;mysql_read_default_group=mysql;host=$name");
+ $dsn = prompt("Enter a DSN string", undef, "DBI:MariaDB:;mariadb_read_default_group=mysql;host=$name");
} until ( $dsn );
}
if ( !$dl_table ) {
@@ -7674,7 +7669,7 @@ sub connect_to_db {
# Compares versions like 5.0.27 and 4.1.15-standard-log
sub version_ge {
my ( $dbh, $target ) = @_;
- my $version = sprintf('%03d%03d%03d', $dbh->{mysql_serverinfo} =~ m/^(\d+).(\d+).(\d+)/g);
+ my $version = sprintf('%03d%03d%03d', $dbh->{mariadb_serverinfo} =~ m/^(\d+).(\d+).(\d+)/g);
return $version ge sprintf('%03d%03d%03d', $target =~ m/(\d+)/g);
}
@@ -7686,7 +7681,7 @@ sub get_driver_status {
next unless $dbhs{$cxn} && $dbhs{$cxn}->{dbh} && $dbhs{$cxn}->{dbh}->{Active};
$vars{$cxn}->{$clock} ||= {};
my $vars = $vars{$cxn}->{$clock};
- my %res = map { $_ =~ s/ +/_/g; $_ } $dbhs{$cxn}->{dbh}->{mysql_stat} =~ m/(\w[^:]+): ([\d\.]+)/g;
+ my %res = map { $_ =~ s/ +/_/g; $_ } $dbhs{$cxn}->{dbh}->{mariadb_stat} =~ m/(\w[^:]+): ([\d\.]+)/g;
map { $vars->{$_} ||= $res{$_} } keys %res;
$vars->{Uptime_hires} ||= get_uptime($cxn);
$vars->{cxn} = $cxn;
@@ -7703,14 +7698,14 @@ sub get_new_db_connection {
my $dsn = $connections{$connection}
or die "No connection named '$connection' is defined in your configuration";
- # don't ask for a username if mysql_read_default_group=client is in the DSN
- if ( !defined $dsn->{have_user} and $dsn->{dsn} !~ /mysql_read_default_group=client/ ) {
+ # don't ask for a username if mariadb_read_default_group=client is in the DSN
+ if ( !defined $dsn->{have_user} and $dsn->{dsn} !~ /mariadb_read_default_group=client/ ) {
my $answer = prompt("Do you want to specify a username for $connection?", undef, 'n');
$dsn->{have_user} = $answer && $answer =~ m/1|y/i;
}
- # don't ask for a password if mysql_read_default_group=client is in the DSN
- if ( !defined $dsn->{have_pass} and $dsn->{dsn} !~ /mysql_read_default_group=client/ ) {
+ # don't ask for a password if mariadb_read_default_group=client is in the DSN
+ if ( !defined $dsn->{have_pass} and $dsn->{dsn} !~ /mariadb_read_default_group=client/ ) {
my $answer = prompt("Do you want to specify a password for $connection?", undef, 'n');
$dsn->{have_pass} = $answer && $answer =~ m/1|y/i;
}
@@ -7939,10 +7934,10 @@ sub load_config {
# write a config
$config{readonly}->{val} = 0 if $opts{w};
# If no connections have been defined, connect to a MySQL database
- # on localhost using mysql_read_default_group=client
+ # on localhost using mariadb_read_default_group=client
if (!%connections) {
add_new_dsn('localhost',
- 'DBI:mysql:;host=localhost;mysql_read_default_group=client',
+ 'DBI:MariaDB:;host=localhost;mariadb_read_default_group=client',
'test.innotop_dl');
}
}
@@ -9374,7 +9369,7 @@ sub choose_thread {
my %thread_for = map {
# Eliminate innotop's own threads.
- $_ => $dbhs{$_}->{dbh} ? $dbhs{$_}->{dbh}->{mysql_thread_id} : 0
+ $_ => $dbhs{$_}->{dbh} ? $dbhs{$_}->{dbh}->{mariadb_thread_id} : 0
} keys %connections;
my @candidates = grep {
@@ -9899,7 +9894,7 @@ Enter; otherwise, you will need to change to innotop's directory and type "perl
innotop".
With no options specified, innotop will attempt to connect to a MySQL server on
-localhost using mysql_read_default_group=client for other connection
+localhost using mariadb_read_default_group=client for other connection
parameters. If you need to specify a different username and password, use the
-u and -p options, respectively. To monitor a MySQL database on another
host, use the -h option.
@@ -10394,15 +10389,15 @@ inputs, as follows:
A DSN is a Data Source Name, which is the initial argument passed to the DBI
module for connecting to a server. It is usually of the form
- DBI:mysql:;mysql_read_default_group=mysql;host=HOSTNAME
+ DBI:MariaDB:;mariadb_read_default_group=mysql;host=HOSTNAME
-Since this DSN is passed to the DBD::mysql driver, you should read the driver's
-documentation at L<"http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql.pm"> for
+Since this DSN is passed to the DBD::MariaDB driver, you should read the driver's
+documentation at L<https://metacpan.org/pod/DBD::MariaDB> for
the exact details on all the options you can pass the driver in the DSN. You
can read more about DBI at L<http://dbi.perl.org/docs/>, and especially at
L<http://search.cpan.org/~timb/DBI/DBI.pm>.
-The mysql_read_default_group=mysql option lets the DBD driver read your MySQL
+The mariadb_read_default_group=mysql option lets the DBD driver read your MySQL
options files, such as ~/.my.cnf on UNIX-ish systems. You can use this to avoid
specifying a username or password for the connection.
@@ -12137,7 +12132,7 @@ You need appropriate privileges to create and drop the deadlock tables if needed
=head1 SYSTEM REQUIREMENTS
You need Perl to run innotop, of course. You also need a few Perl modules: DBI,
-DBD::mysql, Term::ReadKey, and Time::HiRes. These should be included with most
+DBD::MariaDB, Term::ReadKey, and Time::HiRes. These should be included with most
Perl distributions, but in case they are not, I recommend using versions
distributed with your operating system or Perl distribution, not from CPAN.
Term::ReadKey in particular has been known to cause problems if installed from
diff --git a/debian/additions/innotop/innotop.1 b/debian/additions/innotop/innotop.1
index 4c705422286..fefea717cd6 100644
--- a/debian/additions/innotop/innotop.1
+++ b/debian/additions/innotop/innotop.1
@@ -184,7 +184,7 @@ Enter; otherwise, you will need to change to innotop's directory and type \*(L"p
innotop\*(R".
.PP
With no options specified, innotop will attempt to connect to a MySQL server on
-localhost using mysql_read_default_group=client for other connection
+localhost using mariadb_read_default_group=client for other connection
parameters. If you need to specify a different username and password, use the
\&\-u and \-p options, respectively. To monitor a MySQL database on another
host, use the \-h option.
@@ -626,16 +626,16 @@ A \s-1DSN\s0 is a Data Source Name, which is the initial argument passed to the
module for connecting to a server. It is usually of the form
.Sp
.Vb 1
-\& DBI:mysql:;mysql_read_default_group=mysql;host=HOSTNAME
+\& DBI:MariaDB:;mariadb_read_default_group=mysql;host=HOSTNAME
.Ve
.Sp
-Since this \s-1DSN\s0 is passed to the DBD::mysql driver, you should read the driver's
-documentation at \*(L"/search.cpan.org/dist/DBD\-mysql/lib/DBD/mysql.pm\*(R"\*(L" in \*(R"http: for
+Since this \s-1DSN\s0 is passed to the DBD::MariaDB driver, you should read the driver's
+documentation at <https://metacpan.org/pod/DBD::MariaDB> for
the exact details on all the options you can pass the driver in the \s-1DSN. \s0 You
can read more about \s-1DBI\s0 at <http://dbi.perl.org/docs/>, and especially at
<http://search.cpan.org/~timb/DBI/DBI.pm>.
.Sp
-The mysql_read_default_group=mysql option lets the \s-1DBD\s0 driver read your MySQL
+The mariadb_read_default_group=mysql option lets the \s-1DBD\s0 driver read your MySQL
options files, such as ~/.my.cnf on UNIX-ish systems. You can use this to avoid
specifying a username or password for the connection.
.IP "InnoDB Deadlock Table" 4
@@ -2095,7 +2095,7 @@ You need appropriate privileges to create and drop the deadlock tables if needed
.SH "SYSTEM REQUIREMENTS"
.IX Header "SYSTEM REQUIREMENTS"
You need Perl to run innotop, of course. You also need a few Perl modules: \s-1DBI,\s0
-DBD::mysql, Term::ReadKey, and Time::HiRes. These should be included with most
+DBD::MariaDB, Term::ReadKey, and Time::HiRes. These should be included with most
Perl distributions, but in case they are not, I recommend using versions
distributed with your operating system or Perl distribution, not from \s-1CPAN.\s0
Term::ReadKey in particular has been known to cause problems if installed from
diff --git a/debian/additions/mysqlreport b/debian/additions/mysqlreport
index 6588b17f808..6ee9f1b1ac9 100755
--- a/debian/additions/mysqlreport
+++ b/debian/additions/mysqlreport
@@ -245,15 +245,15 @@ sub connect_to_MySQL
if($mycnf{'socket'} && -S $mycnf{'socket'})
{
- $dsn = "DBI:mysql:mysql_socket=$mycnf{socket}";
+ $dsn = "DBI:MariaDB:mariadb_socket=$mycnf{socket}";
}
elsif($mycnf{'host'})
{
- $dsn = "DBI:mysql:host=$mycnf{host}" . ($mycnf{port} ? ";port=$mycnf{port}" : "");
+ $dsn = "DBI:MariaDB:host=$mycnf{host}" . ($mycnf{port} ? ";port=$mycnf{port}" : "");
}
else
{
- $dsn = "DBI:mysql:host=localhost";
+ $dsn = "DBI:MariaDB:host=localhost";
}
print "connect_to_MySQL: DBI DSN: $dsn\n" if $op{debug};
diff --git a/debian/additions/mysqlreport.1 b/debian/additions/mysqlreport.1
index 5ae6b9e3b92..29435193ec1 100644
--- a/debian/additions/mysqlreport.1
+++ b/debian/additions/mysqlreport.1
@@ -160,7 +160,7 @@ command line option and operation. The FROM: field is
\fB\-\-flush\-status\fR
Execute a "FLUSH STATUS;" after generating the reports.
If you do not have permissions in MySQL to do this an
-error from DBD::mysql::st will be printed after the
+error from DBD::MariaDB::st will be printed after the
reports.
.SH "AUTHORS"
diff --git a/debian/control b/debian/control
index 9082bf52b03..30fadc33b01 100644
--- a/debian/control
+++ b/debian/control
@@ -356,7 +356,7 @@ Provides: default-mysql-client,
mysql-client-5.6,
mysql-client-5.7,
virtual-mysql-client
-Recommends: libdbd-mysql-perl (>= 1.2202),
+Recommends: libdbd-mariadb-perl,
libdbi-perl,
libterm-readkey-perl
Description: MariaDB database client binaries
diff --git a/man/mysql_convert_table_format.1 b/man/mysql_convert_table_format.1
index 0c35c295419..faa35afbe56 100644
--- a/man/mysql_convert_table_format.1
+++ b/man/mysql_convert_table_format.1
@@ -26,7 +26,7 @@ by default)\&.
is written in Perl and requires that the
DBI
and
-DBD::mysql
+DBD::MariaDB
Perl modules be installed (see
Section\ \&2.15, \(lqPerl Installation Notes\(rq)\&.
.PP
diff --git a/man/mysql_setpermission.1 b/man/mysql_setpermission.1
index f20f7ceff35..f2f5e3e039c 100644
--- a/man/mysql_setpermission.1
+++ b/man/mysql_setpermission.1
@@ -25,7 +25,7 @@ is a Perl script that was originally written and contributed by Luuk de Boer\&.
is written in Perl and requires that the
DBI
and
-DBD::mysql
+DBD::MariaDB
Perl modules be installed\&.
.PP
Invoke
diff --git a/mysql-test/include/have_dbi_dbd-mysql.inc b/mysql-test/include/have_dbi_dbd-mariadb.inc
index 7c2113a8109..1495d2891c8 100644
--- a/mysql-test/include/have_dbi_dbd-mysql.inc
+++ b/mysql-test/include/have_dbi_dbd-mariadb.inc
@@ -1,7 +1,7 @@
#
# Originally created by John Embretsen, 2011-01-26.
#
-# Checks for the existence of Perl modules DBI and DBD::mysql as seen from the
+# Checks for the existence of Perl modules DBI and DBD::MariaDB as seen from the
# perl installation used by "external" executable perl scripts, i.e. scripts
# that are executed as standalone scripts interpreted by the perl installation
# specified by the "shebang" line in the top of these scripts.
@@ -30,7 +30,7 @@
# We jump through some hoops since there is no direct way to check if an
# external command went OK or not from a mysql-test file:
#
-# - In theory, we could do as simple as "exec perl -MDBI -MDBD::mysql -e 1",
+# - In theory, we could do as simple as "exec perl -MDBI -MDBD::MariaDB -e 1",
# however we cannot check the result (exit code) from within a test script.
# Also, this may not yield the same result as other uses of perl due to the
# shebang issue mentioned above.
@@ -55,8 +55,8 @@
# Instead, we call a separate helper script which checks for the modules in its
# own environment. We call it without "perl" in front.
---let $perlChecker= $MYSQLTEST_VARDIR/std_data/checkDBI_DBD-mysql.pl
---let $resultFile= $MYSQL_TMP_DIR/dbidbd-mysql.txt
+--let $perlChecker= $MYSQLTEST_VARDIR/std_data/checkDBI_DBD-MariaDB.pl
+--let $resultFile= $MYSQL_TMP_DIR/dbiDBD-MariaDB.txt
--exec perl $perlChecker
@@ -64,7 +64,7 @@
--source $resultFile
if (!$dbidbd) {
- --skip Test needs Perl modules DBI and DBD::mysql
+ --skip Test needs Perl modules DBI and DBD::MariaDB
}
# Clean up
diff --git a/mysql-test/include/mysqlhotcopy.inc b/mysql-test/include/mysqlhotcopy.inc
index 2fc14d599d9..306f0acc208 100644
--- a/mysql-test/include/mysqlhotcopy.inc
+++ b/mysql-test/include/mysqlhotcopy.inc
@@ -4,7 +4,7 @@
--source include/not_windows.inc
--source include/not_embedded.inc
---source include/have_dbi_dbd-mysql.inc
+--source include/have_dbi_dbd-mariadb.inc
if (!$MYSQLHOTCOPY)
{
@@ -19,7 +19,7 @@ if (!$MYSQLHOTCOPY)
# executable, i.e. not necessarily using the perl interpreter in PATH,
# because that is how the documentation demonstrates it.
#
-# We include have_dbi_dbd-mysql.inc above so that the test will
+# We include have_dbi_dbd-mariadb.inc above so that the test will
# be skipped if Perl modules required by the mysqlhotcopy tool are not
# found when the script is run this way.
diff --git a/mysql-test/std_data/checkDBI_DBD-mysql.pl b/mysql-test/std_data/checkDBI_DBD-MariaDB.pl
index 328a7ad774f..ed0f5b415d7 100755
--- a/mysql-test/std_data/checkDBI_DBD-mysql.pl
+++ b/mysql-test/std_data/checkDBI_DBD-MariaDB.pl
@@ -20,7 +20,7 @@
################################################################################
#
# This perl script checks for availability of the Perl modules DBI and
-# DBD::mysql using the "current" perl interpreter.
+# DBD::MariaDB using the "current" perl interpreter.
#
# Useful for test environment checking before testing executable perl scripts
# in the MySQL Server distribution.
@@ -30,8 +30,8 @@
# support running perl scripts with such a shebang without specifying the
# perl interpreter on the command line. Such a script is mysqlhotcopy.
#
-# When run as "checkDBI_DBD-mysql.pl" the shebang line will be evaluated
-# and used. When run as "perl checkDBI_DBD-mysql.pl" the shebang line is
+# When run as "checkDBI_DBD-MariaDB.pl" the shebang line will be evaluated
+# and used. When run as "perl checkDBI_DBD-MariaDB.pl" the shebang line is
# not used.
#
# NOTE: This script will create a temporary file in MTR's tmp dir.
@@ -43,13 +43,13 @@
#
# Example:
#
-# --let $perlChecker= $MYSQLTEST_VARDIR/std_data/checkDBI_DBD-mysql.pl
-# --let $resultFile= $MYSQL_TMP_DIR/dbidbd-mysql.txt
+# --let $perlChecker= $MYSQLTEST_VARDIR/std_data/checkDBI_DBD-MariaDB.pl
+# --let $resultFile= $MYSQL_TMP_DIR/dbiDBD-MariaDB.txt
# --chmod 0755 $perlChecker
# --exec $perlChecker
# --source $resultFile
# if (!$dbidbd) {
-# --skip Test needs Perl modules DBI and DBD::mysql
+# --skip Test needs Perl modules DBI and DBD::MariaDB
# }
#
# The calling script is also responsible for cleaning up after use:
@@ -59,7 +59,7 @@
# Windows notes:
# - shebangs may work differently - call this script with "perl " in front.
#
-# See mysql-test/include/have_dbi_dbd-mysql.inc for example use of this script.
+# See mysql-test/include/have_dbi_dbd-mariadb.inc for example use of this script.
# This script should be executable for the user running MTR.
#
################################################################################
@@ -69,13 +69,13 @@ BEGIN {
# We need to catch "Can't locate" as well as "Can't load" errors.
eval{
$FOUND_DBI=0;
- $FOUND_DBD_MYSQL=0;
+ $FOUND_DBD_MARIADB=0;
# Check for DBI module:
$FOUND_DBI=1 if require DBI;
- # Check for DBD::mysql module
- $FOUND_DBD_MYSQL=1 if require DBD::mysql;
+ # Check for DBD::MariaDB module
+ $FOUND_DBD_MARIADB=1 if require DBD::MariaDB;
};
};
@@ -83,11 +83,11 @@ BEGIN {
# The file must be created whether we write to it or not, otherwise mysql-test
# will complain if trying to source it.
# An empty file indicates failure to load modules.
-open(FILE, ">", $ENV{'MYSQL_TMP_DIR'}.'/dbidbd-mysql.txt');
+open(FILE, ">", $ENV{'MYSQL_TMP_DIR'}.'/dbiDBD-MariaDB.txt');
-if ($FOUND_DBI && $FOUND_DBD_MYSQL) {
+if ($FOUND_DBI && $FOUND_DBD_MARIADB) {
# write a mysql-test command setting a variable to indicate success
- print(FILE 'let $dbidbd= FOUND_DBI_DBD-MYSQL;'."\n");
+ print(FILE 'let $dbidbd= FOUND_DBI_DBD-MARIADB;'."\n");
}
# close the file.
diff --git a/plugin/handler_socket/client/hspool_test.pl b/plugin/handler_socket/client/hspool_test.pl
index 7fe073301b1..091cb4967cb 100755
--- a/plugin/handler_socket/client/hspool_test.pl
+++ b/plugin/handler_socket/client/hspool_test.pl
@@ -31,8 +31,8 @@ my $moreflds_prefix = get_conf("moreflds_prefix", "f");
my $mysql_user = 'root';
my $mysql_password = '';
-my $dsn = "DBI:mysql:database=;host=$host;port=$mysqlport"
- . ";mysql_server_prepare=$ssps";
+my $dsn = "DBI:MariaDB:database=;host=$host;port=$mysqlport"
+ . ";mariadb_server_prepare=$ssps";
my $dbh = DBI->connect($dsn, $mysql_user, $mysql_password,
{ RaiseError => 1 });
my $hsargs = { 'host' => $host, 'port' => $hsport_rd };
diff --git a/plugin/handler_socket/client/hstest.pl b/plugin/handler_socket/client/hstest.pl
index 4d177b6cdc8..de39fcb6d6c 100755
--- a/plugin/handler_socket/client/hstest.pl
+++ b/plugin/handler_socket/client/hstest.pl
@@ -33,8 +33,8 @@ my $moreflds_prefix = get_conf("moreflds_prefix", "column0123456789_");
my $keytype = get_conf("keytype", "varchar(32)");
my $file = get_conf("file", undef);
-my $dsn = "DBI:mysql:database=;host=$host;port=$mysqlport"
- . ";mysql_server_prepare=$ssps";
+my $dsn = "DBI:MariaDB:database=;host=$host;port=$mysqlport"
+ . ";mariadb_server_prepare=$ssps";
my $dbh = DBI->connect($dsn, $mysqluser, $mysqlpass, { RaiseError => 1 });
my $hsargs = { 'host' => $host, 'port' => $hsport };
my $cli = new Net::HandlerSocket($hsargs);
diff --git a/plugin/handler_socket/regtest/common/hstest.pm b/plugin/handler_socket/regtest/common/hstest.pm
index 348242b027f..89f273c9786 100644
--- a/plugin/handler_socket/regtest/common/hstest.pm
+++ b/plugin/handler_socket/regtest/common/hstest.pm
@@ -29,10 +29,10 @@ sub get_dbi_connection {
= ($conf{dbname}, $conf{host}, $conf{myport}, $conf{ssps},
$conf{user}, $conf{pass});
my $mycnf = "binary_my.cnf";
- my $dsn = "DBI:mysql:database=;host=$host;port=$myport"
- . ";mysql_server_prepare=$ssps"
- . ";mysql_read_default_group=perl"
- . ";mysql_read_default_file=../common/$mycnf";
+ my $dsn = "DBI:MariaDB:database=;host=$host;port=$myport"
+ . ";mariadb_server_prepare=$ssps"
+ . ";mariadb_read_default_group=perl"
+ . ";mariadb_read_default_file=../common/$mycnf";
my $dbh = DBI->connect($dsn, $user, $pass, { RaiseError => 1 });
return $dbh;
}
diff --git a/scripts/mysql_convert_table_format.sh b/scripts/mysql_convert_table_format.sh
index 2001efae392..6b4d758a513 100644
--- a/scripts/mysql_convert_table_format.sh
+++ b/scripts/mysql_convert_table_format.sh
@@ -57,10 +57,10 @@ if ($opt_port)
}
if (length($opt_socket))
{
- $connect_opt.=";mysql_socket=$opt_socket";
+ $connect_opt.=";mariadb_socket=$opt_socket";
}
-$dbh = DBI->connect("DBI:mysql:$opt_database:${opt_host}$connect_opt",
+$dbh = DBI->connect("DBI:MariaDB:$opt_database:${opt_host}$connect_opt",
$opt_user,
$opt_password,
{ PrintError => 0})
diff --git a/scripts/mysql_setpermission.sh b/scripts/mysql_setpermission.sh
index 71462d28622..66decbd69af 100644
--- a/scripts/mysql_setpermission.sh
+++ b/scripts/mysql_setpermission.sh
@@ -86,7 +86,7 @@ if ($opt_password eq '')
# make the connection to MariaDB
-$dbh= DBI->connect("DBI:mysql:mysql:host=$sqlhost:port=$opt_port:mysql_socket=$opt_socket",$opt_user,$opt_password, {PrintError => 0}) ||
+$dbh= DBI->connect("DBI:MariaDB:mysql:host=$sqlhost:port=$opt_port:mariadb_socket=$opt_socket",$opt_user,$opt_password, {PrintError => 0}) ||
die("Can't make a connection to the mysql server.\n The error: $DBI::errstr");
# the start of the program
diff --git a/scripts/mysqlhotcopy.sh b/scripts/mysqlhotcopy.sh
index c56cdea470c..94e577a94a7 100644
--- a/scripts/mysqlhotcopy.sh
+++ b/scripts/mysqlhotcopy.sh
@@ -192,12 +192,12 @@ $opt{allowold} = 1 if $opt{keepold};
my $dsn;
$dsn = ";host=" . (defined($opt{host}) ? $opt{host} : "localhost");
$dsn .= ";port=$opt{port}" if $opt{port};
-$dsn .= ";mysql_socket=$opt{socket}" if $opt{socket};
+$dsn .= ";mariadb_socket=$opt{socket}" if $opt{socket};
-# use mysql_read_default_group=mysqlhotcopy so that [client] and
+# use mariadb_read_default_group=mysqlhotcopy so that [client] and
# [mysqlhotcopy] groups will be read from standard options files.
-my $dbh = DBI->connect("dbi:mysql:$dsn;mysql_read_default_group=mysqlhotcopy",
+my $dbh = DBI->connect("DBI:MariaDB:$dsn;mariadb_read_default_group=mysqlhotcopy",
$opt{user}, $opt{password},
{
RaiseError => 1,
@@ -796,7 +796,7 @@ sub record_log_pos {
my $row_hash = get_row_hash( $dbh, "show slave status" );
my ($master_host, $log_file, $log_pos );
- if ( $dbh->{mysql_serverinfo} =~ /^3\.23/ ) {
+ if ( $dbh->{mariadb_serverinfo} =~ /^3\.23/ ) {
($master_host, $log_file, $log_pos )
= @{$row_hash}{ qw / Master_Host Log_File Pos / };
} else {
diff --git a/scripts/mytop.sh b/scripts/mytop.sh
index 3ef0a59f27f..1c4d7a502f5 100644
--- a/scripts/mytop.sh
+++ b/scripts/mytop.sh
@@ -230,11 +230,11 @@ my $dsn;
## Socket takes precedence.
-$dsn ="DBI:mysql:database=$config{db};mysql_read_default_group=mytop;";
+$dsn ="DBI:MariaDB:database=$config{db};mariadb_read_default_group=mytop;";
if ($config{socket} and -S $config{socket})
{
- $dsn .= "mysql_socket=$config{socket}";
+ $dsn .= "mariadb_socket=$config{socket}";
}
else
{
@@ -1877,7 +1877,7 @@ following:
* Perl 5.005 or newer
* Getopt::Long
- * DBI and DBD::mysql
+ * DBI and DBD::MariaDB
* Term::ReadKey from CPAN
Most systems are likely to have all of those installed--except for
diff --git a/sql-bench/server-cfg.sh b/sql-bench/server-cfg.sh
index 3991d16c6b1..6ef39c4d91f 100644
--- a/sql-bench/server-cfg.sh
+++ b/sql-bench/server-cfg.sh
@@ -116,8 +116,8 @@ sub new
bless $self;
$self->{'cmp_name'} = "mysql";
- $self->{'data_source'} = "DBI:mysql:database=$database;host=$host";
- $self->{'data_source'} .= ";mysql_socket=$socket" if($socket);
+ $self->{'data_source'} = "DBI:MariaDB:database=$database;host=$host";
+ $self->{'data_source'} .= ";mariadb_socket=$socket" if($socket);
$self->{'data_source'} .= ";$connect_options" if($connect_options);
$self->{'limits'} = \%limits;
$self->{'blob'} = "blob";
diff --git a/storage/maria/ma_ft_test1.h b/storage/maria/ma_ft_test1.h
index 0f4997a7142..df86eeceb66 100644
--- a/storage/maria/ma_ft_test1.h
+++ b/storage/maria/ma_ft_test1.h
@@ -311,7 +311,7 @@ struct { const char *f0, *f2; } data[NDATAS] = {
{"18.4.49", "Problems linking with the C API"},
{"18.4.50", "How to make a thread-safe client"},
{"18.5", "MySQL Perl API's"},
- {"18.5.1", "DBI with DBD::mysql"},
+ {"18.5.1", "DBI with DBD::MariaDB"},
{"18.5.1.1", "The DBI interface"},
{"18.5.1.2", "More DBI/DBD information"},
{"18.6", "MySQL Java connectivity (JDBC)"},
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/rqg.inc b/storage/rocksdb/mysql-test/rocksdb/t/rqg.inc
index 40154d9eaa7..0f3246de06f 100644
--- a/storage/rocksdb/mysql-test/rocksdb/t/rqg.inc
+++ b/storage/rocksdb/mysql-test/rocksdb/t/rqg.inc
@@ -25,8 +25,8 @@ foreach $grammar_file (split(/ /, $ENV{'GRAMMAR_FILES'})) {
# Errors from the gentest.pl file will be captured in the results file
my $cmd = "perl $ENV{'RQG_BASE'}/gentest.pl " .
- "--dsn=dbi:mysql:host=:port=:user=root:database=$ENV{'TESTDB'}" .
- ":mysql_socket=$ENV{'MYSQL_SOCKET'} " .
+ "--dsn=DBI:MariaDB:host=:port=:user=root:database=$ENV{'TESTDB'}" .
+ ":mariadb_socket=$ENV{'MYSQL_SOCKET'} " .
"--gendata=$ENV{'RQG_BASE'}/conf/$ENV{'TESTDIR'}/$ENV{'DATA_FILE'} " .
"--grammar=$ENV{'RQG_BASE'}/conf/$ENV{'TESTDIR'}/$grammar_file " .
"--threads=5 --queries=10000 --duration=60 --sqltrace 2>&1 >> " .
diff --git a/tests/big_record.pl b/tests/big_record.pl
index cb1f8998468..b2aeee27658 100755
--- a/tests/big_record.pl
+++ b/tests/big_record.pl
@@ -37,9 +37,9 @@ GetOptions("host=s","db=s","user=s", "password=s", "table=s", "rows=i",
print "Connection to database $test_db\n";
$extra_options="";
-$extra_options.=":mysql_compression=1" if ($opt_compress);
+$extra_options.=":mariadb_compression=1" if ($opt_compress);
-$dbh = DBI->connect("DBI:mysql:$opt_db:$host$extra_options",$opt_user,$opt_password) || die "Can't connect: $DBI::errstr\n";
+$dbh = DBI->connect("DBI:MariaDB:$opt_db:$host$extra_options",$opt_user,$opt_password) || die "Can't connect: $DBI::errstr\n";
$dbh->do("drop table if exists $opt_table");
@@ -65,7 +65,7 @@ for ($i=0 ; $i < $opt_rows ; $i++)
print "\nReading records\n";
-$sth=$dbh->prepare("select * from $opt_table", { "mysql_use_result" => 1}) or die $dbh->errstr;
+$sth=$dbh->prepare("select * from $opt_table", { "mariadb_use_result" => 1}) or die $dbh->errstr;
$sth->execute() or die $sth->errstr;
diff --git a/tests/check_async_queries.pl b/tests/check_async_queries.pl
index b599bc334d3..0039dd90eb9 100644
--- a/tests/check_async_queries.pl
+++ b/tests/check_async_queries.pl
@@ -13,7 +13,7 @@ my $D= [];
die "Usage: $0 <host> <user> <password> <database>\n"
unless @ARGV == 4;
-my $dbh= DBI->connect("DBI:mysql:database=$ARGV[3];host=$ARGV[0]",
+my $dbh= DBI->connect("DBI:MariaDB:database=$ARGV[3];host=$ARGV[0]",
$ARGV[1], $ARGV[2],
{ RaiseError => 1, PrintError => 0 });
diff --git a/tests/consistent_snapshot.pl b/tests/consistent_snapshot.pl
index 9e53eaea6a1..5c006b0092d 100755
--- a/tests/consistent_snapshot.pl
+++ b/tests/consistent_snapshot.pl
@@ -17,7 +17,7 @@ my $DURATION= 20;
my $stop_time= time() + $DURATION;
sub my_connect {
- my $dbh= DBI->connect("dbi:mysql:mysql_socket=/tmp/mysql.sock;database=test",
+ my $dbh= DBI->connect("DBI:MariaDB:mariadb_socket=/tmp/mysql.sock;database=test",
"root", undef, { RaiseError=>1, PrintError=>0, AutoCommit=>0});
$dbh->do("SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ");
$dbh->do("SET SESSION autocommit = 0");
diff --git a/tests/drop_test.pl b/tests/drop_test.pl
index 329f65eb65d..15a75f4908c 100755
--- a/tests/drop_test.pl
+++ b/tests/drop_test.pl
@@ -50,7 +50,7 @@ $firsttable = "bench_f1";
$start_time=new Benchmark;
if (!$opt_skip_create)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table if exists $firsttable, ${firsttable}_1, ${firsttable}_2");
@@ -81,7 +81,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table $firsttable");
@@ -103,7 +103,7 @@ sub test_insert
{
my ($dbh,$i);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
for ($i=0 ; $i < $opt_loop_count; $i++)
@@ -124,7 +124,7 @@ sub test_drop
my ($id) = @_;
my ($dbh,$i,$sth,$error_counter,$sleep_time);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$error_counter=0;
@@ -169,7 +169,7 @@ sub test_select
{
my ($dbh,$i,$sth,@row,$error_counter,$sleep_time);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -206,7 +206,7 @@ sub test_flush
{
my ($dbh,$i,$sth,@row,$error_counter,$sleep_time);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/fork_big.pl b/tests/fork_big.pl
index 623377ab5cd..2f803b7fdd3 100755
--- a/tests/fork_big.pl
+++ b/tests/fork_big.pl
@@ -65,7 +65,7 @@ srand 100; # Make random numbers repeatable
####
$start_time=new Benchmark;
-$dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+$dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
if (!$opt_skip_create)
@@ -155,7 +155,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
my $table_def;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -189,7 +189,7 @@ sub test_insert
$from_table=0; $to_table=$numtables-1;
}
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -218,7 +218,7 @@ sub test_select
{
my ($dbh, $i, $j, $count, $loop, $count_query, $row_counts);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -255,7 +255,7 @@ sub test_select_count
{
my ($dbh, $i, $j, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -285,7 +285,7 @@ sub test_join
{
my ($dbh, $i, $j, $count, $loop, $count_query, $row_counts);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -326,7 +326,7 @@ sub test_delete
$table_count=2;
$count=0;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -360,7 +360,7 @@ sub test_delete
sub test_update
{
my ($dbh, $i, $j, $row_counts, $count_query, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -403,7 +403,7 @@ sub test_update
sub test_check
{
my ($dbh, $sth, $row, $i, $j, $type, $table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -440,7 +440,7 @@ sub test_check
sub test_repair
{
my ($dbh, $sth, $row, $i, $type, $table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -474,7 +474,7 @@ sub test_flush
{
my ($dbh,$count,$tables);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -502,7 +502,7 @@ sub test_database
{
my ($database) = @_;
my ($dbh, $sth, $row, $i, $type, $tables);
- $dbh = DBI->connect("DBI:mysql:$database:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$database:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -535,7 +535,7 @@ sub test_database
sub test_alter
{
my ($dbh, $sth, $row, $i, $type, $table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -559,7 +559,7 @@ sub test_alter
sub signal_abort
{
my ($dbh);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/fork_big2.pl b/tests/fork_big2.pl
index c844d290834..a2b465734dc 100644
--- a/tests/fork_big2.pl
+++ b/tests/fork_big2.pl
@@ -81,7 +81,7 @@ if ($opt_time == 0 && $opt_insert == 0)
}
$start_time=new Benchmark;
-$dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+$dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
if (!$opt_skip_create)
@@ -212,7 +212,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_drop && !$errors)
{
my $table_def;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -257,7 +257,7 @@ sub test_insert
$from_table=0; $to_table=$numtables-1;
}
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -286,7 +286,7 @@ sub test_select
{
my ($dbh, $i, $j, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -323,7 +323,7 @@ sub test_select_count
{
my ($dbh, $i, $j, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -353,7 +353,7 @@ sub test_join
{
my ($dbh, $i, $j, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -391,7 +391,7 @@ sub test_join_count
{
my ($dbh, $i, $j, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -446,7 +446,7 @@ sub test_delete
$table_count=2;
$count=0;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -480,7 +480,7 @@ sub test_delete
sub test_update
{
my ($dbh, $i, $j, $row_counts, $count_query, $count, $loop);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -523,7 +523,7 @@ sub test_update
sub test_check
{
my ($dbh, $row, $i, $j, $type, $table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -560,7 +560,7 @@ sub test_check
sub test_repair
{
my ($dbh, $row, $i, $type, $table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -594,7 +594,7 @@ sub test_flush
{
my ($dbh,$count,$tables);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -621,7 +621,7 @@ sub test_resize
{
my ($dbh, $key_buffer_size);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -648,7 +648,7 @@ sub test_database
{
my ($database) = @_;
my ($dbh, $row, $i, $type, $tables);
- $dbh = DBI->connect("DBI:mysql:$database:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$database:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -681,7 +681,7 @@ sub test_database
sub test_alter
{
my ($dbh, $row, $i, $type, $table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -705,7 +705,7 @@ sub test_alter
sub signal_abort
{
my ($dbh);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/grant.pl b/tests/grant.pl
index cd651643316..f8cdc1af4d5 100755
--- a/tests/grant.pl
+++ b/tests/grant.pl
@@ -60,7 +60,7 @@ unlink($tmp_table);
# clear grant tables
#
-$dbh = DBI->connect("DBI:mysql:mysql:$opt_host",
+$dbh = DBI->connect("DBI:MariaDB:mysql:$opt_host",
$opt_root_user,$opt_password,
{ PrintError => 0}) || die "Can't connect to mysql server with user '$opt_root_user': $DBI::errstr\n";
@@ -653,7 +653,7 @@ sub user_connect
print "Connecting $opt_user\n" if ($opt_verbose);
$user_dbh->disconnect if (defined($user_dbh));
- $user_dbh=DBI->connect("DBI:mysql:$opt_database:$opt_host",$opt_user,
+ $user_dbh=DBI->connect("DBI:MariaDB:$opt_database:$opt_host",$opt_user,
$password, { PrintError => 0});
if (!$user_dbh)
{
diff --git a/tests/index_corrupt.pl b/tests/index_corrupt.pl
index 6b04ce8a59c..6f31b85bd61 100755
--- a/tests/index_corrupt.pl
+++ b/tests/index_corrupt.pl
@@ -51,7 +51,7 @@ $kill_file= "/tmp/mysqltest_index_corrupt.$$";
$start_time=new Benchmark;
if (!$opt_skip_create)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table if exists $firsttable, $secondtable");
@@ -111,7 +111,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table $firsttable, $secondtable");
@@ -134,7 +134,7 @@ sub insert_in_bench
{
my ($dbh,$rows,$found,$i);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
for ($rows= 1; $rows <= $opt_loop_count ; $rows++)
@@ -179,7 +179,7 @@ sub select_from_bench
{
my ($dbh,$rows,$cursor);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
for ($rows= 1; $rows < $opt_loop_count ; $rows++)
@@ -206,7 +206,7 @@ sub delete_from_bench
{
my ($dbh,$row, $t_value, $t2_value, $statement, $cursor);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/insert_and_repair.pl b/tests/insert_and_repair.pl
index 18091c92718..dfa490456cb 100755
--- a/tests/insert_and_repair.pl
+++ b/tests/insert_and_repair.pl
@@ -49,7 +49,7 @@ $secondtable = "bench_f2";
$start_time=new Benchmark;
if (!$opt_skip_create)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table if exists $firsttable, $secondtable");
@@ -79,7 +79,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table $firsttable,$secondtable");
@@ -100,7 +100,7 @@ sub insert_in_bench1
{
my ($dbh,$rows,$found,$i);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$rows=$found=0;
@@ -123,7 +123,7 @@ sub insert_in_bench2
{
my ($dbh,$rows,$found,$i);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$rows=$found=0;
@@ -149,7 +149,7 @@ sub repair_and_check
$table);
$found1=$found2=0; $last_found1=$last_found2= -1;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/mail_to_db.pl b/tests/mail_to_db.pl
index e50415d96f3..94f3955b2c3 100755
--- a/tests/mail_to_db.pl
+++ b/tests/mail_to_db.pl
@@ -110,12 +110,12 @@ sub main
die "FATAL: Can't find inbox file: $ARGV[$i]\n" if (! -f $ARGV[$i]);
}
- $connect_arg = "DBI:mysql:";
+ $connect_arg = "DBI:MariaDB:";
push @args, "database=$opt_db" if defined($opt_db);
push @args, "host=$opt_host" if defined($opt_host);
push @args, "port=$opt_port" if defined($opt_port);
- push @args, "mysql_socket=$opt_socket" if defined($opt_socket);
- push @args, "mysql_read_default_group=mail_to_db";
+ push @args, "mariadb_socket=$opt_socket" if defined($opt_socket);
+ push @args, "mariadb_read_default_group=mail_to_db";
$connect_arg .= join ';', @args;
$dbh = DBI->connect("$connect_arg", $opt_user, $opt_password,
{ PrintError => 0})
diff --git a/tests/pmail.pl b/tests/pmail.pl
index 359256c25b3..de469923c7d 100755
--- a/tests/pmail.pl
+++ b/tests/pmail.pl
@@ -60,7 +60,7 @@ if ($opt_help || !$ARGV[0])
#### Connect and parsing the query to MySQL
####
-$dbh= DBI->connect("DBI:mysql:$opt_db:$opt_host:port=$opt_port:mysql_socket=$opt_socket", $opt_user,$opt_password, { PrintError => 0})
+$dbh= DBI->connect("DBI:MariaDB:$opt_db:$opt_host:port=$opt_port:mariadb_socket=$opt_socket", $opt_user,$opt_password, { PrintError => 0})
|| die $DBI::errstr;
main();
diff --git a/tests/rename_test.pl b/tests/rename_test.pl
index d7097df1e4e..ff1b73434e5 100755
--- a/tests/rename_test.pl
+++ b/tests/rename_test.pl
@@ -48,7 +48,7 @@ $firsttable = "bench_f1";
$start_time=new Benchmark;
if (!$opt_skip_create)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table if exists $firsttable, ${firsttable}_1, ${firsttable}_2");
@@ -81,7 +81,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$dbh->do("drop table $firsttable");
@@ -103,7 +103,7 @@ sub test_insert
{
my ($dbh,$i,$error);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
for ($i=0 ; $i < $opt_loop_count; $i++)
@@ -128,7 +128,7 @@ sub test_rename
my ($id) = @_;
my ($dbh,$i,$error_counter,$sleep_time);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
$error_counter=0;
@@ -158,7 +158,7 @@ sub test_select
{
my ($dbh,$i,$sth,@row,$sleep_time);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -192,7 +192,7 @@ sub test_flush
{
my ($dbh,$i,$sth,@row,$error_counter,$sleep_time);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/test_delayed_insert.pl b/tests/test_delayed_insert.pl
index cb5b86a228d..2ebb42e08d1 100755
--- a/tests/test_delayed_insert.pl
+++ b/tests/test_delayed_insert.pl
@@ -50,7 +50,7 @@ $secondtable = "bench_f2";
$start_time=new Benchmark;
if (!$opt_skip_create)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$Mysql::QUIET = 1;
$dbh->do("drop table if exists $firsttable,$secondtable");
$Mysql::QUIET = 0;
@@ -87,7 +87,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$dbh->do("drop table $firsttable");
$dbh->do("drop table $secondtable");
}
@@ -107,7 +107,7 @@ sub test_1
{
my ($dbh,$tmpvar,$rows,$found,$i);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=1;
$rows=$found=0;
for ($i=0 ; $i < $opt_loop_count; $i++)
@@ -131,7 +131,7 @@ sub test_delayed_1
{
my ($dbh,$tmpvar,$rows,$found,$i,$id);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=1;
$rows=$found=0;
for ($i=0 ; $i < $opt_loop_count; $i++)
@@ -162,7 +162,7 @@ sub test_delayed_2
{
my ($dbh,$tmpvar,$rows,$found,$i,$id);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=1;
$rows=$found=0;
for ($i=0 ; $i < $opt_loop_count; $i++)
@@ -196,7 +196,7 @@ sub test_2
{
my ($dbh,$id,$tmpvar,$rows,$found,$i,$max_id,$tmp,$sth,$count);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=111111;
$rows=$found=$max_id=$id=0;
for ($i=0 ; $i < $opt_loop_count ; $i++)
@@ -245,7 +245,7 @@ sub test_2
sub test_3
{
my ($dbh,$id,$tmpvar,$rows,$i,$count);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=222222;
$rows=0;
for ($i=0 ; $i < $opt_loop_count ; $i++)
@@ -269,7 +269,7 @@ sub test_3
sub test_4
{
my ($dbh,$id,$tmpvar,$rows,$i,$count);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=333333;
$rows=0;
for ($i=0 ; $i < $opt_loop_count; $i++)
@@ -288,7 +288,7 @@ sub test_4
sub test_5
{
my ($dbh,$id,$tmpvar,$rows,$i,$max_id,$count,$sth);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$tmpvar=444444;
$rows=$max_id=0;
for ($i=0 ; $i < $opt_loop_count ; $i++)
@@ -328,7 +328,7 @@ sub test_5
sub test_del
{
my ($dbh,$min_id,$i,$sth,$rows);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host") || die $DBI::errstr;
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host") || die $DBI::errstr;
$rows=0;
for ($i=0 ; $i < $opt_loop_count/3; $i++)
{
@@ -357,7 +357,7 @@ sub test_flush
my ($dbh,$sth,$found1,$last_found1,$i,@row);
$found1=0; $last_found1=-1;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
diff --git a/tests/truncate.pl b/tests/truncate.pl
index 98791a15b2c..85a7888bc4a 100755
--- a/tests/truncate.pl
+++ b/tests/truncate.pl
@@ -47,7 +47,7 @@ print "Testing truncate from $opt_threads multiple connections $opt_loop_count t
####
$start_time=new Benchmark;
-$dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+$dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
if (!$opt_skip_create)
@@ -100,7 +100,7 @@ while (($pid=wait()) != -1)
if (!$opt_skip_delete && !$errors)
{
my $table_def;
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;
@@ -127,7 +127,7 @@ sub test_truncate
{
my ($dbh,$i,$j,$count,$table_def,$table);
- $dbh = DBI->connect("DBI:mysql:$opt_db:$opt_host",
+ $dbh = DBI->connect("DBI:MariaDB:$opt_db:$opt_host",
$opt_user, $opt_password,
{ PrintError => 0}) || die $DBI::errstr;