Custom message for KILL STATEMENT
Details
| Detail name | Value |
|---|---|
| Changelog Number | 4807 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 6.0.12 |
| Resolution Date | 2018-08-23 |
Background
The statement KILL allows terminating a foreign session or query. In case of a killed query the affected user may continue working on the database but does not know why the query was terminated.
Feature Description
It is now possible to specify a message when killing a query. The affected user will see the message as part of the error message for the terminated query.
Example Usage
KILL STATEMENT IN SESSION 123 WITH MESSAGE 'example';
For details, see section "KILL" in the Exasol User Manual.
Benefits
The affected users can be informed about the reason for terminated queries and can adapt their usage of the database.
Restrictions
A message may only be specified when terminating a query, not when terminating a whole session.