Informix - Problem description
| Problem IT08631 | Status: Closed |
INSERT WITH SUBQUERY GETS ZERO ROWS IF EXECUTED FROM AN UPDATABLE SECONDARY | |
| product: | |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 | |
| Problem description: | |
You are using Informix with updatable HDR secondary instance. You noticed that if you do an insert with a subquery on the secondary, then on the very first execution zero rows is inserted. Consequent executions insert correct number of rows. | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.04.2015 30.12.2015 30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) | |
12.10.xC6 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 12.10.xC6 |
|