Queries on system tables having filters with invalid values may crash

Details

Detail name Value
Changelog Number 16048
Type Bug
Status Resolved
Affected Versions Exasol 7.1.12, Exasol 7.1.13, Exasol 8.2.0, Exasol 8.3.0, Exasol 8.4.0, Exasol 7.1.14, Exasol 8.5.0, Exasol 8.6.0, Exasol 8.7.0, Exasol 8.8.0, Exasol 7.1.15, Exasol 7.1.16
Fix Versions Exasol 8.9.0, Exasol 7.1.17
Resolution Date 2023-01-12

Description

On certain system tables queries having filters using invalid values result in query crashes (internal server error) instead of the expected “data exception” error message.

Example

select * from exa_all_objects where created > '2022-11-41 12:57:05.614285'

Workaround

There is no workaround

Fix

Those queries raise a “data exception“ error instead of crashing.