GROUP_CONCAT function misses default separator on HASHTYPE if used as an analytical function
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11051 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 6.2.0, Exasol 7.0.0 |
| Fix Versions | Exasol 7.0.4 |
| Resolution Date | 2020-11-26 |
Description
The result of the GROUP_CONCAT function misses the default separator ',' if all of the following conditions are met:
- GROUP_CONCAT function is used as an analytic function (using over-clause)
- GROUP_CONCAT is used on HASHTYPE data type
- no SEPARATOR is defined explicitly
Example
SELECT GROUP_CONCAT(hashtype_column) OVER () FROM t;
Workaround
Specify the separator explicitly:
SELECT GROUP_CONCAT(hashtype_column SEPARATOR ',') OVER () FROM t;
Fix
GROUP_CONCAT will return the results including the default separator in the above case.
