| 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 | ||
| Category: | Server: Docs | Severity: | S3 (Non-critical) |
| Version: | N/A | OS: | N/A |
| Assigned to: | Paul DuBois | Target Version: | |
| Triage: | D4 (Minor) | ||
[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.
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: .