| Subject: | Tie::DBI vs DBD::mysqlPP, sql LISTFIELDS bug (and fix) |
| Date: | Thu, 21 Mar 2013 11:12:29 -0700 (PDT) |
| To: | "bug-Tie-DBI [...] rt.cpan.org" <bug-Tie-DBI [...] rt.cpan.org> |
| From: | pete w <mechiepete [...] yahoo.com> |
Tie::DBI with DBD::mysqlPP was crashing out with the server saying it didn't support LISTFIELDS.
my setup (i don't think it is specific to any of this):
strawberry perl 5.16.3 64-bit
on windows 8 64-bit
mysql server version 5.6
modules freshly installed using CPAN...
Indeed the DBD::mysqlPP documentation says you cannot use LISTFIELDS.
DBI.pm already has a workaround for this but it was not activated for mysqlPP.
I was able to update the following file:
.../perl/site/lib/Tie/DBI.pm around line 38 :
my %CANNOT_LISTFIELDS = (
'SQLite' => 1,
'Oracle' => 1,
'mysqlPP' => 1 ######## added this to fix problem
);
Would appreciate if you added this?
Thanks, let me know / feel free to contact me
-Pete Weisz
PS- is there a way to change the %CANNOTLISTFIELDS from the code "use"ing Tie::DBI?
PPS- Many, many thanks for maintaining these awesomely useful tools!