Prepare of UPDATE on booloean column fails

Detail name	Value
Changelog Number	8012
Type	Bug
Status	Resolved
Affected Versions	EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.beta1, Exasol 6.2.8
Fix Versions	Exasol 7.0.0, Exasol 6.1.5, Exasol 6.2.13
Resolution Date	2020-09-11

Problem Description

If a table with more than one column, has one boolean column:

create table t(a timestamp, b boolean);

The prepare call of this UPDATE fails

update t set a=?, b=?;

Te following error is returned:

Cannot cast from TIMESTAMP to BOOLEAN

Workaround

You can prepare and execute the UDPATE if you switch the columns in the SET clause:

update t set b=?, a=?;