INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

If you attempt to use the create index online syntax and 1 of
the keys of the index is of the boolean type, the statement will
fail immediately with a -212/-21522 error.

For example:

create table t1 (
col_int integer,
col_bool boolean,
col_char char(8)
) lock mode row;

create index t1_idx1 on t1 (col_int, col_bool) using btree
online;

The above create index statement will fail with a -212/-21522
error.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS versions prior to 12.10.xC14.                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Error -212/-21522 trying to use create index online when one *
* of the keys of the index is of type boolean.                 *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.04.2019
24.09.2019
24.09.2019

12.10.xC14