tsucchi/p5-Net-MySQL — Issue #2: Net::MySQL hangs for query results with one record
Author: mnikhil-git
Created: 2012-01-02 16:54:55+00:00
State: open

Hi,

I have checked that for the SELECT queries performed on the table/views with only one record, the session hangs for almost indefinite in Net::MySQL.

I think this behaviour is due to the way the packet/column length is processed in checking whether the returned query length is type of select query (or update query) and the recv function from IO::Socket is made to wait indefinitely unnecessary.

This case is reproducible for the results with one record or packet length of 1 byte.

Packet length of 1 byte are of generally from the table maintenance statements like Optimize, Repair table etc.,.