Wrong results for UDFs in VALUES on multi-node systems

Detail name	Value
Changelog Number	7960
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0
Fix Versions	Exasol 7.1.2, Exasol 7.0.14
Resolution Date	2021-10-20

Bug

Using UDF scripts in the VALUES clause causes wrong results on multi-node systems: Instead of creating one row, sometimes zero or up to the number of nodes rows are created, each containing a different value returned by the UDF script.

How To Reproduce

With any UDF script udf() returning nondeterministic values:

INSERT INTO t VALUES (udf());

Workaround

Using the udf in a SELECT LIST instead of a VALUES CLAUSE is not affected by this bug and works as expected:

INSERT INTO t SELECT udf();