Incorrect results in filter evaluation for columns of type char() ascii and hash type

Detail name	Value
Changelog Number	13710
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0, Exasol 6.2.17, Exasol 7.0.14, Exasol 7.1.3
Fix Versions	Exasol 8.0.0, Exasol 6.2.18, Exasol 7.1.4, Exasol 7.0.15
Resolution Date	2021-12-22

Description

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

• a filter is used
• the column used in the filter is of one of the following types

• HASHTYPE( n ) with n > 32 byte
• CHAR( n ) ASCII with n > 32

VARCHAR() and CHAR() UTF8 are not affected.

Workaround

Contact support for a database parameter. The workaround may cause some performance deteriorations.

Fix

Filters return correct results.