IF-statement with constant (like true or false) may fail

Detail name	Value
Changelog Number	12723
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.0.0, Exasol 7.1.0
Fix Versions	Exasol 7.1.4, Exasol 7.0.15
Resolution Date	2021-12-22

Background

Exasol 7.0 introduced an alternative syntax, the IF-statement to the CASE-statement

Description

Currently using a (boolean) constant in the IF-condition may cause an "Internal Server Error".

Preparation

create or replace table t as select 1 as a;

Example

select if true then a endif from t;

Workaround

Use CASE-statements instead of IF-statements.
Example

select case when true then a end from t;

Fix

IF-statement does not cause an error.