| 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> |
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';