Skip Menu |
 

This queue is for tickets about the DBD-ADO CPAN distribution.

Report information
The Basics
Id: 100953
Status: open
Priority: 0/
Queue: DBD-ADO

People
Owner: Nobody in particular
Requestors: rdbprog [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: column_info () Fails When FetchHashKeyName Attribute Is Not 'NAME'
Date: Tue, 16 Dec 2014 15:45:17 -0500
To: bug-DBD-ADO [...] rt.cpan.org
From: Robert Boisvert <rdbprog [...] gmail.com>
Download (untitled) / with headers
text/plain 849b
Greetings, While developing with DBD-ADO version 2.99 I ran into an obscure bug. When I open a SQLServer Express 2005 database (dbi:ADO:Provider=SQLNCLI;Integrated Security=SSPI;Initial Catalog=Test;Data Source=\SQLEXPRESS) with the FetchHashKeyName attribute set to 'NAME_lc', the column_info () function fails when it tries to retrieve information. It produces the following error: Use of uninitialized value in hash element at C:/perl/site/lib/DBD/ADO/TypeInfo.pm line 472. The sequence below is a workaround for ADO but does not support the other drivers I am using. Is it possible to recode so that regardless of the FetchHashKeyName setting it still works? Thank you for considering this request, Bob $oDB->{FetchHashKeyName} = 'NAME'; $oSTH = $oDB->column_info (undef, $sSchema, $sTable, undef); $oDB->{FetchHashKeyName} = 'NAME_lc';
Download (untitled) / with headers
text/plain 284b
Thanks for the report! I'm very busy in this weeks and unplugged for the next few weeks - so please be patient. From a first look: In TypeInfo.pm line 472, there is a SELECT of its own (for TypeInfo metadata). Maybe the sub Find3 needs a local $sth->{FetchHashKeyName} = 'NAME';


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.