Killing own session with KILL SESSION is not working using a prepared statement
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5370 |
| Type | Bug |
| Status | Open |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0 |
Executing KILL SESSION CURRENT_SESSION as a prepared statement will lead to following exception:
Exception when finishing statement with handle <handle_id> : Connection was killed
After this the session can still be used for executing queries.
Workaround
KILL SESSION CURRENT_SESSION will work if it is executed as a statement.
You can also terminate the session by using the close/disconnect method of the used driver.
