Bug #31251 perl dbi empty result set
Submitted: 27 Sep 2007 17:36 Modified: 27 Oct 2007 18:38
Reporter: tim kuz Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:5.0.22-2.1.0.1 OS:Linux (2.6.18-8.1.8.el5)
Assigned to: CPU Architecture:Any
Tags: dbi, Empty Result Set, perl

[27 Sep 2007 17:36] tim kuz 
Description:
I'm using a centos 5 os with perl version 4:5.8.8-10.  I have a script that performs a simple select statement (select * from table) and returns an empty result set when there are entries present.  I know there are entries in the db, because I login to the client and perform the query.  This only appears to happen on a certain table.  One thing that is weird is that I used to have this problem for two tables, then I altered one of the table's columns and the other one started working.

How to repeat:
Setup a perl script that performs a simple query on a db table and output the results to the console.
[27 Sep 2007 18:38] Valeriy Kravchuk 
Please, send SHOW CREATE TABLE results and Perl script that demonstrates the problem.
[27 Oct 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".