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.