ALTER SESSION RESET does not work in ISQL, results in error "Cannot reset user
session - There are open transactions (2 active)"
--------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6384
URL: http://tracker.firebirdsql.org/browse/CORE-6384
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 4.0 Beta 2
Environment: 4.0.0.2133-0 on Windows 10 64-bit
Reporter: Mark Rotteveel
As isql uses two transactions, it is not possible to execute ALTER SESSION
RESET. Doing so results in the following error:
D:\DevSoft\FB_tests\Firebird-4.0.0.2133-0_x64>isql -user sysdba -password
masterkey localhost:employee
Database: localhost:employee, User: SYSDBA
SQL> alter session reset;
Statement failed, SQLSTATE = 01002
Cannot reset user session
-There are open transactions (2 active)
SQL>
Given the requirement that there is no active transaction (or only the current
transaction executing ALTER SESSION RESET), it looks like ISQL needs to get
special treatment for handling ALTER SESSION RESET, for example on detection of
ALTER SESSION RESET, commit both transaction, or something similar.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
