OUT OF MEMORY and crash in SQL Compiler for too complex expressions
Details
| Detail name | Value |
|---|---|
| Changelog Number | 6990 |
| Type | Bug |
| Status | Open |
| Affected Versions |
Problem
For very complex select list expressions (for instance deeply nested CASE expressions), the SQL compiler may run out of memory and crash.
Workaround
This can only be fixed by either increasing the heap memory of the SQL process or by (preferably) simplifying the query.
