MySQL Bugs: #8779: result set fetch size is ignored

Bug #8779	result set fetch size is ignored
Submitted:	24 Feb 2005 15:36	Modified:	3 Mar 2005 22:21
Reporter:	Quartz 12h	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / J	Severity:	S2 (Serious)
Version:	3.1	OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The statement.setFetchSize() is not honored.
The driver 'RowDataDynamic ' could fairly easily do some fetching of a limited number of rows.

How to repeat:
step into RowDataDynamic code while pulling rows out of the resultset.

Suggested fix:
Instead of a RowDataDynamic for 1 by 1 record download, the
RowDataDynamic could be fetching precisely the number of rows allowed by setFetchSize() just like bufferedinputstream does its fillbuffer whenever it's empty.

MySQL-5.0 has actual fetch support in the protocol, and Connector/J 3.2.x supports this through Statement.setFetchSize().

We will not be implementing this for MySQL-4.1.