Bug #21943 Lack of documentation about ER_SP_FETCH_NO_DATA (Zero rows fetched in cursor)
Submitted: 31 Aug 2006 9:47 Modified: 6 Sep 2006 18:52
Reporter: Tobias Asplund Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:N/A OS:N/A
Assigned to: Paul DuBois CPU Architecture:Any

[31 Aug 2006 9:47] Tobias Asplund
Description:
I think it would be a nice idea to add some more documentation under cursors                       about the "no data" handling of a cursor, currently there's the example under 
the main cursor page (http://dev.mysql.com/doc/refman/5.0/en/cursors.html), but it has no explanation.
Maybe under the cursor fetch section (http://dev.mysql.com/doc/refman/5.0/en/fetch.html) add that a cursor will return an error with a sql state '02000' when there's no more data to be fetched

How to repeat:
.
[6 Sep 2006 18:52] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

I added a description of No Data to the FETCH section and
a cross-reference to the example in the Cursors section.