Rare error for certain IN-list constants in combination with an existing index

Detail name	Value
Changelog Number	7378
Type	Bug
Status	Resolved
Affected Versions	Exasol 6.1.0
Fix Versions	Exasol 6.1.2
Resolution Date	2019-02-19

Background

Certain constant values in the IN-list lead to an 'Internal Server Error' if there exists an index on the query columns.
Example:

CREATE SCHEMA test;
CREATE OR REPLACE TABLE t(c1 VARCHAR(100));
INSERT INTO t VALUES 0,1,2,3,4; 
ENFORCE INDEX ON t(c1);
SELECT c1 FROM t WHERE c1 IN ('AAAAAZM8G');

Workaround

Drop the index or replace the IN-list with a different query.
Example:

DROP INDEX on t(c1);
SELECT c1 FROM t WHERE c1 IN ('AAAAAZM8G');
-- or
SELECT c1 FROM t WHERE c1 = 'AAAAAZM8G';