DUMP function return type can be too small for some inputs causing an internal server error or invalid results
Details
| Detail name | Value |
|---|---|
| Changelog Number | 30131 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0, Exasol 2025.1.0, Exasol 2025.2.0, Exasol 2026.1.0 |
| Fix Versions | Exasol 2026.1.1, Exasol 2025.1.12 |
| Resolution Date | 2026-07-02 |
Description
The DUMP function chooses the size of its VARCHAR return type based on the data type of the first parameter. If the second parameter format is 8 or 10 (the default value), this return type size can be too small for some input strings containing big UTF-8 characters, causing an internal server error or invalid results.
Example
SELECT DUMP(REPEAT('😎', 250));
Workaround
Cast the first parameter to a bigger string type.
SELECT DUMP(CAST(REPEAT('😎', 250) AS VARCHAR(2000000)));
Fix
The size of the VARCHAR return type increased by five characters. Only the data type changed, the returned values remain unchanged.
Changed behavior
For the DUMP function, the size of its VARCHAR return type increased by five characters. Only the data type changed, the returned values remain unchanged.