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

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: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

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

Daniel Kasak wrote:

>
> my $sth = "select * from any_table where 0=1";

Yeah. Make that:
my $sth = $dbh->prepare("select * from any_table where 0=1");

O:-)

--
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: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org