Informix - Problem description
Problem IT20025 | Status: Closed |
INSERT INTO ... SELECT ... SILENTLY INSERTING NULL BLOBS RATHERTHAN FAILING WHEN TARGET BLOBSPACE IS FULL | |
product: | |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 | |
Problem description: | |
Inserting into a blobspace blob (TEXT or BYTE) column using 'INSERT INTO ... SELECT ...' (or 'CREATE TABLE AS SELECT ...') syntax would silently ignore 'blobspace full' condition and carry on leaving blob fields with NULL values. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Using legacy blobs (TEXT, BYTE). * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to at least 12.10.xC9. * **************************************************************** | |
Local Fix: | |
Ensure storagepool has room for blobspace extension. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.04.2017 09.06.2017 09.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |