Large number of chained operands causes internal server error

Detail name	Value
Changelog Number	6860
Type	Bug
Status	Open
Affected Versions	Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0

Background:

A single expression with a large number of same-priority operands (>5000) causes an internal server error.

Example:

CREATE SCHEMA test;
CREATE TABLE T1(col0 int, col1 int, ..., col5000 int, ..., col10000 int);
SELECT col0 + col1 + ... + col5000 + ... + col10000 from T1;

Workaround:

Add parentheses to split up the expression.

Example

SELECT (col0 + col1 + ... + col5000) + (... + col10000) from T1;

Note

This also affects subtraction, division, multiplication and concatenation (||).