This queue is for tickets about the Class-DBI-Plugin-Pager CPAN distribution.

Report information
The Basics
Id:
12369
Status:
resolved
Priority:
Low/Low

People
Owner:
cpan.zerofive [...] googlemail.com
Requestors:
dave [...] riverside-cms.co.uk
Cc:
AdminCc:

BugTracker
Severity:
Normal
Broken in:
0.6_4
Fixed in:
0.55



Subject: column alias bug
Using this trick $where = { 1 => 1 }; to retrieve all rows works fine with 0.55, but under 0.6_4 i have error "no such column 1 in table myboard" Not sure if this error also happens with retrieve_all() in 0.6_4
[DAVEBAIRD - Thu Apr 21 10:27:31 2005]:
Show quoted text
> Using this trick > > $where = { 1 => 1 }; > > to retrieve all rows works fine with 0.55, > but under 0.6_4 i have error "no such column 1 in table myboard" > > Not sure if this error also happens with retrieve_all() in 0.6_4
I have observed this bug using both 0.55 and 0.56. I'm pretty sure about the cause being Class::DBI::Plugin::AbstractCount, which introduces sanity checking for column names passed to the where clause in version 0.04 - hence the above error message. Please see attached archive for a self contained test case and patch for Class::DBI::Plugin::Pager 0.56 to provide a fix. Verfied on Win32 with ActivePerl 5.8.4. hth, keep up the good work. Will Hawes <info@whawes.co.uk>

Message body not shown because it is not plain text.

[guest - Tue Jul 19 11:53:04 2005]:
Show quoted text
> [DAVEBAIRD - Thu Apr 21 10:27:31 2005]: >
> > Using this trick > > > > $where = { 1 => 1 }; > > > > to retrieve all rows works fine with 0.55, > > but under 0.6_4 i have error "no such column 1 in table myboard" > > > > Not sure if this error also happens with retrieve_all() in 0.6_4
> > I have observed this bug using both 0.55 and 0.56. I'm pretty sure about > the cause being Class::DBI::Plugin::AbstractCount, which introduces > sanity checking for column names passed to the where clause in version > 0.04 - hence the above error message. > > Please see attached archive for a self contained test case and patch for > Class::DBI::Plugin::Pager 0.56 to provide a fix. Verfied on Win32 with > ActivePerl 5.8.4. > > hth, keep up the good work. > > Will Hawes <info@whawes.co.uk> >
Thanks Will, applied in 0.561 d.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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