INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

n version 12.10, starting with xC1, a prepared query running
nicely in v11.70 suddenly takes long, consumig lots of cpu time.

The query, involving a derived table, uses host variables, in
projection clause (CASE expressions) as well as filters, and all
of them are being UPPER(?)'ed.

Same query using literals, with or without UPPER(), or host
variables without UPPER()ing, running well, all using same query
plan.
Same effect also using e.g. TRIM() instead of UPPER().

Same query in 11.70 also had its special query plan (different
from that of the three variants), but not a bad (slow) one.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS prior to 12.10.xC13.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Prepared query using functions on host variables choosing    *
* wrong index, causing long query run time.                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.12.2018
03.10.2019
03.10.2019

12.10.xC13