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.