Inserting of long repeating UTF8 character sequences is very slow

Details

Detail name Value
Changelog Number 15858
Type Bug
Status Resolved
Affected Versions Exasol 7.1.0, Exasol 8.0.0, Exasol 8.29.0, Exasol 2025.1.0, Exasol 2025.2.0
Fix Versions Exasol 2026.1.0, Exasol 2025.1.12
Resolution Date 2026-05-15

Description

Inserting of long repeating UTF8 characters sequences is very slow.
Example:

CREATE TABLE largeChars1(c1 varchar(2000000), c2 int);
INSERT INTO largeChars1 VALUES (REPEAT(UNICODECHR(127153),2000000), 0); -- Takes 35 seconds!

Workaround

There is no workaround.

Fix

The insertion of long repeating UTF8 characters is faster.