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.