GROUP_CONCAT crashes for UDFs with fixed size CHARACTER return type when the UDF returns too few characters
Details
| Detail name | Value |
|---|---|
| Changelog Number | 7700 |
| Type | Bug |
| Status | Open |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0 |
How to reproduce:
--/
CREATE OR REPLACE LUA SCALAR SCRIPT too_small() returns char(17) UTF8 AS
function run(ctx)
return('too_small')
end
/
SELECT group_concat(too_small());
This query crashes.
Workarounds
1. Return the correct number of characters (17) in the UDF
2. Declare the UDF to have return type VARCHAR instead of CHAR.
For instance, this version
CREATE OR REPLACE LUA SCALAR SCRIPT too_small() returns VARCHAR(17) UTF8 AS
function run(ctx)
return('too_small')
end
/
works.
