Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 20037
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: slloyd [...] timequest.org
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 3.0006_1
Fixed in: 2.9004



Subject: select query works with version 2.9004, fails on latest version.
Download (untitled) / with headers
text/plain 263b
The following simple query fails with the latest dbd-mysql driver. select * from _fielddata where tablename like '_pages' and fieldname in ('name','template','description','parent','status','sort_order','publish','body') I rolled back to 2.9004 and all was well.
Download (untitled) / with headers
text/plain 577b
Works in current version (3.0007) my $dbh= DBI->connect("DBI:mysql:test:localhost", "root", "", { PrintError => 0}) || die $DBI::errstr; my $sth= $dbh->prepare("select * from _fielddata where tablename like '_pages' and fieldname in ('name','template','description','parent','status','sort_order','publish','body')"); print "error: " . $DBI::errstr . "\n" if $DBI::errstr; $sth->execute(); my $ar_ref= $sth->fetchall_arrayref(); print Dumper $ar_ref; radha:~ patg$ perl -e 'use DBD::mysql; print $DBD::mysql::VERSION . "\n"' 3.0007


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.