Possible query crash when using LIMIT and global joins
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5030 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASolution 5.0.20 |
| Fix Versions | EXASOL 6.0.3, EXASolution 5.0.21 |
| Resolution Date | 2017-09-26 |
Query Elements:
- Global join between at least two tables
- LIMIT without ORDER BY
Symptom:
Caused by a rare race condition, such queries may abort unexpectedly, resulting in Internal Server Error and/or Successfully Reconnected error messages.
There is no workaround, except to re-run the query.