Bug #12369 for Class-DBI-Plugin-Pager: column alias bug

Thu Apr 21 10:27:31 2005 cpan.zerofive [...] googlemail.com - Ticket created

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

Tue Jul 19 11:53:04 2005 Guest - Correspondence added

[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>

Download 12369.zip
application/zip 1.9k

Message body not shown because it is not plain text.

Wed Jul 20 10:51:30 2005 cpan.zerofive [...] googlemail.com - Taken

Sun Jul 31 12:25:50 2005 cpan.zerofive [...] googlemail.com - Status changed from 'new' to 'resolved'

Sun Jul 31 12:25:50 2005 cpan.zerofive [...] googlemail.com - Correspondence added

[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.