Query abort when using UDFs on groups, large varchars, and aggregated functions
Details
| Detail name | Value |
|---|---|
| Changelog Number | 4818 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, EXASolution 5.0.0 |
| Fix Versions | EXASolution 5.0.20, EXASOL 6.0.3 |
| Resolution Date | 2017-07-14 |
In some cases, when a query uses UDFs operating on groups (SET-EMITS or SET-RETURNS), process large varchars, and use aggregated functions (group by), it mail fail
Preconditions
The following conditions must be met by the query in order for the bug to occur.
- UDFs operating on groups (SET-EMITS or SET-RETURNS)
- Large varchars are being processed (an average size of at least 8000)
- Aggregated functions (group by)
Effects
The query does not finish execution and generates an internal server error and an associated coredump.
There is no workaround.
