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.