Thanks for the suggestion; unfortunately it produces the same results.
print "\nTesting no placeholders, no results $dsn\n";
my $sth = $dbh->prepare("select 'test' where 1=0");
print Dumper $dbh->selectall_arrayref($sth);
print "\nTesting placeholders with results $dsn\n";
my $sthSecond = $dbh->prepare("select ? where 1=1");
print Dumper $dbh->selectall_arrayref($sthSecond);
print "\nTesting placeholders with no results $dsn\n";
my $sthThird = $dbh->prepare("select ? where 1=0");
print Dumper $dbh->selectall_arrayref($sthThird);
Results:
Testing no placeholders, no results dbi:Sybase:server=xxx.xxx.xxx.xxx
$VAR1 = [];
Testing placeholders with results dbi:Sybase:server=xxx.xxx.xxx.xxx
$VAR1 = [
[
undef
]
];
Testing placeholders with no results dbi:Sybase:server=xxx.xxx.xxx.xxx
$VAR1 = [];
Testing no placeholders, no results dbi:Sybase:server=xxx.xxx.xxx.xxx;
+tdsLevel=CS_TDS_495
$VAR1 = [];
Testing placeholders with results dbi:Sybase:server=xxx.xxx.xxx.xxx;td
+sLevel=CS_TDS_495
$VAR1 = [
[
undef
]
];
Testing placeholders with no results dbi:Sybase:server=xxx.xxx.xxx.xxx
+;tdsLevel=CS_TDS_495
(hang)
|