Still got "Socket receive buffer full" exception

[yihuang]

I have a table which has a blob field, and when i want to query all data from it, i got "Socket receive buffer full".
And when i increase the MYSQL_PACKET_SIZE from (1024 * 1024 * 16) to (1024 * 1024 * 32), it's disappeared.

alldata = list(executeSQL('select * from table_with_big_blob_field', ()).rows)

[jskorpan]

That is expected. The umysql driver doesn't use streaming but instead retreives the entire result set in memory.

//JT

On 24 jun 2013, at 15:03, "yihuang" <notifications@git.luolix.topmailto:notifications@github.com> wrote:

I have a table which has a blob field, and when i want to query all data from it, i got "Socket receive buffer full".
And when i increase the MYSQL_PACKET_SIZE from (1024 * 1024 * 16) to (1024 * 1024 * 32), it's disappeared.

alldata = list(executeSQL('select * from table_with_big_blob_field', ()).rows)`

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/34.

[V-E-O]

This figure has related to query size too big problem? If so, can this figure be able to set when build the connection? In some environment, large query is needed and query size is controlled by server-side.

[jkbbwr]

This issue still exists, can you please provide a solution that allows users to run queries on sets larger than your buffer size without manually setting limits in SQL