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
|
# Test special characters inside comments
# http://bugs.debian.org/311040
# http://bugs.mysql.com/27625
use strict;
use warnings;
use DBI;
use Test::More;
use vars qw($test_dsn $test_user $test_password $state);
require "t/lib.pl";
my $dbh;
eval {$dbh= DBI->connect($test_dsn, $test_user, $test_password,
{ RaiseError => 1, PrintError => 0, AutoCommit => 0 });};
if ($@) {
plan skip_all => "no database connection";
}
my %tests = (
questionmark => " -- Does the question mark at the end confuse DBI::MySQL?\nselect ?",
quote => " -- 'Tis the quote that confuses DBI::MySQL\nSELECT ?"
);
for my $test ( sort keys %tests ) {
my $sth = $dbh->prepare($tests{$test});
ok($sth, 'created statement hande');
ok($sth->execute(), 'executing');
ok($sth->{ParamValues}, 'values');
ok($sth->finish(), 'finish');
}
ok ($dbh->disconnect(), 'disconnecting from dbh');
done_testing;
|
