Possible abort of CREATE TABLE AS statement with window functions

Detail name	Value
Changelog Number	9588
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.2.0, Exasol 7.0.alpha1
Fix Versions	Exasol 6.2.x
Resolution Date	2023-03-28

Description

We have identified a race condition that occurs during a CREATE TABLE AS statement;
affected statements/sessions are aborted with internal server error, the transaction is rolled back.

Conditions for the problem to occur:

• Multi-node cluster
• Window functions (aka. analytic functions) present in the SELECT part of the statement

Occurrence Rate

In some rare scenarios, this error seems to occur with around 50% probability, although it is difficult to reproduce in other scenarios.

Workaround

As a workaround, you can split the CREATE TABLE AS statement into a regular CREATE / INSERT pair.