INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A select query using CONNECT BY clause with PRIOR applied to a
varchar column returns error 26079 when value has the same
starting character(s) than the one from the prior row handled.

A table with 2 varchar columns and 2 rows:

col 1    col 2
 00       01
 01       0

The following query will return error -26079:

  SELECT col1, col2
    FROM tab
   START WITH col1 = '00'
   CONNECT BY col1 = PRIOR col2;

****************************************************************
* USERS AFFECTED:                                              *
* Users of 12.10.xC1 through 12.10.xC6                         *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* A CONNECT BY query may return incorrect error code under the *
* following conditions:                                        *
*  - a varchar(n) column is used as CONNECT BY PRIOR column    *
*  - rows in table have different actual length for the        *
* varchar column, some shorter than others                     *
*  - values for a shorter row matches a prefix of at least one *
* longer row                                                   *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC7                      *
****************************************************************

Work around: Change column type to char.

not known / see Local fix

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

22.12.2015
28.06.2016
28.06.2016

12.10.xC7