|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!