Invalid use of data types leads to internal server error

Details

Detail name Value
Changelog Number 7303
Type Bug
Status Resolved
Affected Versions Exasol 6.1.0
Fix Versions Exasol 6.1.1
Resolution Date 2019-01-04

Background

The use of datatype keywords (e.g., DATE, TIMESTAMP) at invalid places leads to an internal server error instead of an appropriate error message in Exasol 6.1.0.

Example:

SELECT DATE FROM (
        Select current_date as "DATE" from dual
);
 SELECT TIMESTAMP FROM (
        SELECT CURRENT_DATE AS "TIMESTAMP"
);
SELECT BOOLEAN FROM (
        SELECT CURRENT_DATE AS "BOOLEAN"
);

Fix

Display of an appropriate error message.

Example:

syntax error, unexpected DATE_