Deadlock in LIMIT without ORDER BY query
Details
| Detail name | Value |
|---|---|
| Changelog Number | 8241 |
| Type | Bug |
| Status | Open |
| Affected Versions | EXASOL 6.0.0 |
Problem
In rare occasions a LIMIT (without ORDER BY) query can be stuck in a deadlock. The probability this happening is higher:
- the more nodes the cluster has
- the less data is in the base table
Workaround
Use ORDER BY LIMIT instead of LIMIT.
