It will take me a while to set up the situation that led to me noticing this bug. I'll let you know the outcome when i get to it. Thanks, Callum
On Tue, Apr 03, 2007 at 08:14:35PM +0200, Raphael Hertzog wrote: > Hi, > > On Fri, 29 Sep 2006, Callum Bell wrote: > > The server allows null values in primary key columns. If there is such a > > value (I have checked int and varchar(16)) a select of just the primary > > key returns no values when the data are retreived with > > $sth->fetchrow_array() even though the table is populated with thousands > > of rows. Using the interactive mysql client the data can be retrieved > > without a problem, including the null value. If $sth->fetchrow_hashref() > > is used instead of $sth->fetchrow_array() the PK data are returned > > correctly. If the select attempts to retrieve more than one column, but > > including the primary key (e.g. select * from...) then a small subset of > > rows are returned. Again, fetchrow_hashref() functions correctly. > > Can you try it out with libdbd-mysql-perl 4.004 that I uploaded to > unstable? It should be available shortly on your mirrors. > > If the problem is still present, then I'll forward the bug upstream. > > > The problem might not be in libdbd-mysql-perl but maybe libdbi-perl? > > I don't know (and I don't feel like debugging it myself right now). > > Cheers, > -- > Raphaël Hertzog > > Premier livre français sur Debian GNU/Linux : > http://www.ouaza.com/livre/admin-debian/
