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_