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.