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

History Show all quoted text
  Wed Jun 21 21:44:20 2006 Guest - Ticket created
Subject: select query works with version 2.9004, fails on latest version.
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.
  Fri Sep 15 12:41:27 2006 CAPTTOFU [...] cpan.org - Correspondence added
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
  Fri Sep 15 12:41:28 2006 The RT System itself - Status changed from 'new' to 'open'
  Fri Sep 15 12:41:29 2006 CAPTTOFU [...] cpan.org - Status changed from 'open' to 'resolved'