INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A query joining two columns where one column's content might be
not fully convertible to the other column's type, might fail
either during sort (if e.g. ORDER BY was used), or subsequent
fetch would return an error - even though the join succeeded and
had silently ignored the error.

For example you'd join an INTEGER to a DECIMAL(13,0) with the
later containing values larger than what an integer can hold.
Such join should be valid and simply not return anything for
those large decimal values.

****************************************************************
* USERS AFFECTED:                                              *
* informix users with PDQ query                                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC7                      *
****************************************************************

Use suitable explicit cast as a workaround.

not known / see Local fix

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

23.03.2016
28.06.2016
28.06.2016

12.10.xC7