Sporadic crashes of queries combining LIMIT and global joins
Details
| Detail name | Value |
|---|---|
| Changelog Number | 4672 |
| Type | Bug |
| Status | Open |
| Affected Versions | EXASolution 5.0.17 |
A query using LIMIT without ORDER BY or GROUP BY can crashe in global join processing. The bug is a very rarely occurring race condition.
The bug could not yet be reproduced. In 5.0.18 there are checks that might help us to localize its source.
Workaround
Adding an ORDER BY clause to the query with LIMIT avoids the problem at the expense of some performance.
