MySQL Bugs: #43889: closing half-read resultset causes is O(n) instead of O(1)

Bug #43889	closing half-read resultset causes is O(n) instead of O(1)
Submitted:	26 Mar 2009 16:07	Modified:	26 Mar 2009 16:28
Reporter:	yoav morag	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: General	Severity:	S5 (Performance)
Version:	5.1	OS:	Linux
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
see the following bug submitted to ConnectorJ and the team response: http://bugs.mysql.com/bug.php?id=42929

I need this functionality because not all data can be selected using where - sometime the user needs to iterate on the data and process it - however it should always be possible to close such a session immediately.

How to repeat:
see java example in : http://bugs.mysql.com/bug.php?id=42929

Change in the protocol that would allow to stop reading the result set at any moment would be useful in some cases.