IMPORT from CSV with REJECT LIMIT UNLIMITED may not finish

Detail name	Value
Changelog Number	13422
Type	Bug
Status	Open
Affected Versions	Exasol 7.0.9

Description

An IMPORT from CSV may not finish and cause the temporary volume to grow, if the following conditions are met:

• COLUMN SEPARATOR is defined and contains multiple characters.
• ERRORS clause is used with REJECT LIMIT UNLIMITED.
• too many errors happen
• CSV file is large enough (e.g. containing more than 1000 rows)

Workaround

Avoid the ERRORS clause completely or set a REJECT limit.

Fix

The IMPORT works as expected.