Incorrect results in queries with multiple range conditions and indexes

Detail name	Value
Changelog Number	15099
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.0.0, Exasol 7.1.0
Fix Versions	Exasol 7.1.12, Exasol 7.0.20
Resolution Date	2022-07-13

Description

A query may return incorrect results if the following conditions are met:

• Query contains multiple WHERE conditions
• At least two conditions allow using an index for filtering
• Those conditions are range conditions (for example a BETWEEN filter)
• The columns in those conditions are of the same or a compatible data type

Workaround

Contact support for the necessary database parameter.

Fix

Queries return correct results in these scenarios, as expected.