Internal server error outer join with JSON_VALUE
Details
| Detail name | Value |
|---|---|
| Changelog Number | 15231 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.0.3, Exasol 7.1.12, Exasol 8.1.0 |
| Fix Versions | Exasol 7.1.13, Exasol 8.4.0 |
| Resolution Date | 2022-08-24 |
Description
If the following conditions are met, a query may fail with the error message "Successfully reconnected after internal server error, transaction was rolled back."
- The query contains an outer join
- The query contains a call to JSON_VALUE
- either with a DEFAULT ... ON ERROR clause
- or without a DEFAULT ... ON EMPTY clause {{}}
Workaround
Change the ON ERROR clause to not use DEFAULT.
Fix
Those queries finish successfully.
