Tests taken from issue 33376

@corona10 This change means that InterfaceError is no longer raised for fetch across rollbacks. This is clearly a change in behaviour, but I can't see how it would break existing apps other than peoples fault handlers not being called :) I guess this also needs a What's New item. I'll expand this in the bpo instead of here.

UPDATE: see msg393944

🤖 New build scheduled with the buildbot fleet by @erlend-aasland for commit f7065b1 🤖

If you want to schedule another build, you need to add the ":hammer: test-with-buildbots" label again.

@serhiy-storchaka, I'm not sure how to proceed in order to land this. I'm pretty sure this is correct; it works across all supported SQLite versions. I've tried to ping Berker about this, but I haven't gotten any response. Proposal: We merge this to main now; it is still early in 3.11 development, so we have plenty of time to get feedback from the community. For example, the Django people have an extensive sqlite3 test suite, and the've been very quick to report regressions or inaccuracies earlier. If, for some reason, we conclude this is the wrong fix, it will be easy to revert it with good margin before the feature freeze/beta.

See the bpo issue for my notes about this fix.

@animalize: would you mind reviewing this?

I will try, I'm not a deep user of SQL, but if you can't find a reviewer I'm glad to try, hope I can review this in 2~4 weeks.

I will try, I'm not a deep user of SQL, but if you can't find a reviewer I'm glad to try, hope I can review this in 2~4 weeks.

Great, thanks. You'll find my reasoning in the bpo.

@ghaering: Would you mind reviewing this? (A 👎🏻 or 👍🏻 reaction would be 👌🏻). Totally understand if you won't.

It seems reset variable can be removed from pysqlite_Cursor struct.
I'm not a core developer, maybe no one listens to my opinion, but I will help you to find problems.

Thanks for helping out, @animalize!

@pablogsal, it would have been nice to get this into the upcoming alpha :)

It seems this PR can be committed. Then to do subsequent improvement.

Thank you, Pablo! 🙏🏻