MDEV-37155 Fix can't break in loop of cursor in oracle mode
In Oracle mode, although the NOT FOUND error cannot be raised when reading data with a cursor, it must be recorded in the current Diagnostics_area, otherwise, it cannot be captured by the NOT FOUND handler, which may result in errors during execution, potentially leading to an infinite loop and other issues.
- [x] The Jira issue number for this PR is: MDEV-______
Description
TODO: fill description here
Release Notes
TODO: What should the release notes say about this change? Include any changed system variables, status variables or behaviour. Optionally list any https://mariadb.com/kb/ pages that need changing.
How can this PR be tested?
TODO: modify the automated test suite to verify that the PR causes MariaDB to behave as intended. Consult the documentation on "Writing good test cases".
If the changes are not amenable to automated testing, please explain why not and carefully describe how to test manually.
Basing the PR against the correct MariaDB version
- [ ] This is a new feature or a refactoring, and the PR is based against the
mainbranch. - [ ] This is a bug fix, and the PR is based against the earliest maintained branch in which the bug can be reproduced.
PR quality check
- [ ] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
- [ ] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.
Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.
zhikong seems not to be a GitHub user. You need a GitHub account to be able to sign the CLA. If you have already a GitHub account, please add the email address used for this commit to your account.
You have signed the CLA already but the status is still pending? Let us recheck it.
It seems you have committed without setting user.email to your github account, the commit shows
From: zhikong <[email protected]>
You either need to add this email to you github account or recommit with the email that github knows. Then it won't be complaining (see above) that "zhikong seems not to be a GitHub user".
@zkong are you still interested completing this PR?