Re: perl script hangs on query with where clause

[Kelly Jones]

I have this problem, using MYSQL 5.0.27 and perl 5.10. In my situation, it appears to happen on some tables and not others. Here was a simple select statement that caused a hang when passed through the DBI call:

>>>> Select sectype from securities where secsym='COP';

A similar simple select with where clause from another table worked fine. I was able to make a work around that eliminated the hang by joining the table of the non-working table with one that did work - not sure at all what the cause was or why this solved the problem, but it did, at least in this instance:

>>>> Select sectype from clients left join positions using (acctnum) left join securities using (secsym) where secsym='COP';

Clients had tested as a non-hanging table. I was surprised not to see more on the Perl site as to what the story is with this bug or errors in setup, whatever the cause.

Hope that may help you at least get functional. It's what we used to call a "kluge" - not the best solution, but lets the wheels of industry move forward...