SUBSTRING and MOD forbid unnecessary parentheses

Detail name	Value
Changelog Number	7166
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0
Fix Versions	Exasol 6.1.1
Resolution Date	2018-12-10

Background

The SQL standard allows for (numeric) values to be nested inside parenthesis in many places. While this was supported with Exasol 6.0, an internal refactoring broke this in some places with Exasol 6.1.0.

Example:

SELECT SUBSTRING('12345678' FROM (2) FOR 3);
SELECT MOD( (10) ,8);

Workaround

Remove the unnecessary parentheses manually or using an SQL preprocessor script.

Example:

SELECT SUBSTRING('12345678' FROM 2 FOR 3);
SELECT MOD(10, 8);