Very strong filters on indexed columns may cause incorrect results

Detail name	Value
Changelog Number	14430
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0
Fix Versions	Exasol 8.0.0, Exasol 7.1.8
Resolution Date	2022-03-24

Description

Filter evaluation may deliver incorrect results causing queries to deliver incorrect results if the following conditions are met:

• A very strong filter is used (only a few rows satisfy the filter condition)
• An index exists containing the column with the strong filter

Workaround

Restart the database and set the following parameter: -useRawCompare=0

Fix

In the scenarios above correct results are returned.