$sth->{'NAME'} and $dbh->column_info() broken in DBD-mysql-3.x ?

Daniel Kasak <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
Greetings.

Further to unresolved issues I'm having with $dbh->column_info ( see 
post of 2005-10-24 ), I've just discovered that $sth->{'NAME'} is also 
not returning a full field list - I get a truncated list of fields, with 
no errors.

I discovered this when building a new box, and accidentally installed 
DBD-mysql-3.0002_p4. On all our clients now, I have to have < 
DBD-mysql-3.0 or our apps fail when retrieving a field list or column info.

Is anyone else able to reproduce these issues? I've reproduced it on a 
number of different systems. The current one is:

Perl 5.8.7
DBD-mysql-3.0002_p4 compiled against mysql-5.0.18 with gcc-4.0.2
Server running mysql-4.1.14

Previously I've tried systems such as:

Perl 5.8.7
DBD-mysql-3.0002_p3 compied against mysql-5.0.something with gcc-3.4.4
Server running mysql-4.1.14

A simple command such as:

my $sth = "select * from any_table where 0=1";
$sth->execute;
my $fieldlist = $sth->{'NAME'};

on *any* table is enough for me to reproduce the problem ... ie the 
fieldlist returned is NOT the full field list.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [email protected]
website: http://www.nusconsulting.com.au

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.