INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

The following query will cause a stack overflow, and an hang of
the instance, if SHMTOTAL is not set:
create database stack_issue;
create table t1 (a int, ord int);
create table t2 (ord int);

insert into t1 values (1, 1);
insert into t2 values (1);
select t1.ord, sum (a)
from t1, t2
where t1.ord = t2.ord
order by 1, (case when ord >10 then ord-12 else ord end)

Note that t1 and t2 have a column with the same name.

As soon as the name of the column is changed, the statement will
work.

The query is causing a loop in oplooksubq, if a stack a gathered
with
onmode -I 722 it will show lots of calls to this function.

****************************************************************
* USERS AFFECTED:                                              *
* Informix user query with order by/group by on same column    *
* name from different tables                                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

Note that t1 and t2 have a column with the same name.

As soon as the name of the column is changed, the statement will
work.

not known / see Local fix

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

21.02.2017
10.07.2017
10.07.2017

12.10.xC9