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 |