Skip Menu |

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

Report information
The Basics
Id: 58581
Status: resolved
Priority: 0/
Queue: DBD-DB2

People
Owner: Nobody in particular
Requestors: gombai.sandor [...] freemail.hu
Cc:
AdminCc:

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



Subject: DBD-DB2 does not return rows from views in syscat schema
Hail to the Maintainer! :) Version 1.78 does not fetch rows for select statements against views in SYSCAT. It works well for their background SYSIBM tables and also for user-created views. No error is raised or printed. The very same sql run by the same user gives the expected result via CLP, and so does using v1.76. OS info: Red Hat Enterprise Linux Server release 5.5, 2.6.18-194.3.1.el5PAE #1 SMP Perl info: v5.8.8 built for i386-linux-thread-multi DB2 info: DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08022" with level identifier "03030106". Informational tokens are "DB2 v8.1.2.88", "s050422", "MI00117", and FixPak "9". make test finishes 100% successfully. Sample: my $sql = q/select * from syscat.tables/; ... my $sth = $dbh->prepare( $sql); $sth->execute; my $colnames = $sth->{NAME_uc}; print "@$colnames\n"; # <- here we have perfect output while ( my @row = $sth->fetchrow_array) { print "@row\n"; } # <- here we have nothing Thanks in advance for any idea!
Hi Sandor, Check this bug report, https://rt.cpan.org/Ticket/Display.html?id=57562 This issue is due to the problem reported in the mentioned ticket (57562). Apply the patch attached in ticket 57562 and give a try, it will work fine. Let me know how it goes. -- Thanks Praveen IBM OpenSource Application Development Team India Software Labs, Bangalore (India)
Subject: Re: [rt.cpan.org #58581] DBD-DB2 does not return rows from views in syscat schema
Date: Wed, 23 Jun 2010 12:31:47 +0200
To: bug-DBD-DB2 [...] rt.cpan.org
From: Sandor Gombai <SGOMBAI [...] hu.ibm.com>
Hi Praveen, indeed, this patch solved the problem! Now, after the case, I must admit that I should have realized the connection between the ticket you gave me and the phenomenon I wrote about which is: there are LOBs in the views I tried the module with while there is no LOB in the tables with the same names. Thanks a lot for the quick answer and sorry for wasting your time - at least I learned something from it. Best regards, Sandor Gombai (sgombai@hu.ibm.com) IT Department Tel.: +36 27 517 242 Cellular: +36 20 823 5049 IBM Data Storage Systems Information Technology Kft Registered in Hungary with number 13-09-107530 by Pest County Court as Company Register Registered office: 16-18 Deákvári fasor, H-2600 Vác "IBM OpenDev via RT" <bug-DBD-DB2@rt.c To pan.org> gombai.sandor@freemail.hu cc 06/22/2010 06:16 PM Subject [rt.cpan.org #58581] DBD-DB2 does not return rows from views in Please respond to syscat schema bug-DBD-DB2@rt.cp an.org <URL: https://rt.cpan.org/Ticket/Display.html?id=58581 > Hi Sandor, Check this bug report, https://rt.cpan.org/Ticket/Display.html?id=57562 This issue is due to the problem reported in the mentioned ticket (57562). Apply the patch attached in ticket 57562 and give a try, it will work fine. Let me know how it goes. -- Thanks Praveen IBM OpenSource Application Development Team India Software Labs, Bangalore (India)
Fix available in version 1.79 -- Thanks Praveen IBM OpenSource Application Development Team India Software Labs, Bangalore (India)