Informix - Problem description
Problem IC60688 | Status: Closed |
AN ERRONEOUS SELECT ON A TEXT COLUMN RETURNS AN INCORRECT ERROR MESSAGE. | |
product: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
Problem description: | |
The error message of the erroneous select on the TEXT column returns an incorrect error message. The error message shows the table name instead of the column name. Example: create table t1(somecolumn TEXT); SELECT t1.unknown FROM t1; 217: Column (t1) not found in any table in the query (or SLV is undefined). The correct error message error should be: 217: Column (unknown) not found in any table in the query (or SLV is undefined). | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * users using TEXT/BYTE column in the table with query on * * non-existing column * **************************************************************** * PROBLEM DESCRIPTION: * * Users using TEXT/BYTE column in the table with query on * * non-existing column, receive error -217 with incorrect * * column name in the message * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS-11.50.xC5 or above. * **************************************************************** | |
Local Fix: | |
Solution | |
Problem has been fixed in IDS-11.50.xC5 to provide the correct column name in the message. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.04.2009 27.07.2009 27.07.2009 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.50.xC4.W1 | |
11.50.xC5 |