Informix - Problem description
Problem IC73675 | Status: Closed |
SQL ERROR -346/-240 FROM UPDATE/DELETE STATEMENT WHEN THE TABLE HAS A FUNCTIONAL INDEX | |
product: | |
INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50 | |
Problem description: | |
An UPDATE or DELETE statement on a table with a functional index might return an error when a table which is used in the functional index was updated before. Error from DELETE statement 240: Could not delete a row. 111: ISAM error: no record found. Error from UPDATE statement 346: Could not update a row in the table. 111: ISAM error: no record found. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users of Informix 11.50.xC8 and earlier versions. * **************************************************************** * PROBLEM DESCRIPTION: * * The Guide to SQL Syntax did not clarify that functional * * indexes must be non-variant. * **************************************************************** * RECOMMENDATION: * * View information in the next published version Informix, * * when it is available. * **************************************************************** | |
Local Fix: | |
Solution | |
Functional indexes must be non-variant. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.01.2011 27.09.2011 27.09.2011 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.50.xC8.W3 | |
11.50.xC9 |