-
-
Notifications
You must be signed in to change notification settings - Fork 205
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Issue with "ALTER SESSION RESET" and implicit cursor close #7625
Comments
Another example for the current issue. execute block
returns (c integer)
as
begin
c=1;suspend;
alter session reset;
c=2;suspend;
end; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Firebird 4.0.3.2948.
Here are two scenarios of using "ALTER SESSION RESET" within transaction with one active cursor.
In both cases fbclient.dll was used.
1. Work with server through TCP/IP (INET)
Here "alter session reset" closes active cursor (stmt00000002).
Client gets the error "invalid request handle" when he tries to fetch from stmt00000002.
Client closes and opens this statement stmt00000002 and gets the error "Attempt to reopen an open cursor"
If these operations execute through IBProvider (OLE DB provider) builtin client for Firebird, before "Attempt to reopen an open cursor" will be an error about cursor close (operation
000012
).2. Work with embedded server
"alter session reset" closes stmt0000000000000002.
[#000012, #000013]
- it is an attemt to close this cursor with "invalid request handle" error.[#000014]
- it is an attempt to drop this statement with "invalid request handle" error.The text was updated successfully, but these errors were encountered: