Informix - Problem description
Problem IT27621 | Status: Closed |
PREPARED QUERY USING FUNCTIONS ON HOST VARIABLES CHOOSING WRONG INDEX CAUSING LONG QUERY RUN TIME | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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. | |
Problem Summary: | |
**************************************************************** * 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: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.12.2018 03.10.2019 03.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |