UDF SET scripts may return duplicated rows in some cases
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10969 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.2.10 |
| Fix Versions | Exasol 6.2.12 |
| Resolution Date | 2020-10-22 |
Description
In some cases, UDF SET scripts may return duplicated rows and will never indicate that all rows were consumed. This may happen if the following conditions are met:
- A query includes a UDF SET script
- The UDF SET script needs to process a large group
- A large group can consist of many small rows or on a few large rows or any mix of it
- the input must be aggregated (with or without an explicit GROUP BY)
Workaround
There is no workaround.
Fix
UDF SET scripts will return the expected number of rows when these conditions are met.
