Package: libdbd-mysql-perl Version: 3.0007-1 My setup: ---------
$ uname -a Linux crocus 2.6.15-1-486 #2 Mon Mar 6 15:19:16 UTC 2006 i686 GNU/Linux ~$ dpkg -l | grep mysql ii libdbd-mysql-perl 3.0007-1 A Perl5 database interface to the MySQL d ata ii libmysqlclient15off 5.0.24a-4 mysql database client library ii mysql-client 5.0.24a-4 mysql database client (current version) ii mysql-client-5.0 5.0.24a-4 mysql database client binaries ii mysql-common 5.0.24a-4 mysql database common files (e.g. /etc/my sql $ dpkg -l | grep dbi ii libdbi-perl 1.52-1 Perl5 database interface by Tim Bunce The server: mysql-standard-5.0.21-linux-x86_64-glibc23 (Not a debian package). The problem: ------------ 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. The problem might not be in libdbd-mysql-perl but maybe libdbi-perl? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
