Informix - Problembeschreibung
Problem IC99134 | Status: Geschlossen |
INSERTING FROM AN EXTERNAL TABLE INTO A REGULAR TABLE CONTAINING A TEXT COLUMN WITH A NULL CONSTRAINT CAN RETURN ERROR 391 | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Consider a regular table with a not null constraint for the text column. If you try to use export and import data from this table by creating an external table, inserting form the regular table into the external table and then inserting the same data back into the orignal table, this last insert will fail with a 391 error, when the blob contains an empty row. If you however unload the data from the regular table and use this unload in the creation of the external table, the data can be inserted back into the regular table. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * external table users having empty strings in BLOB TEXT * * columns * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 12.10.xC5 or earlier PID if available * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.02.2014 16.10.2015 16.10.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC5 | |
Problem behoben lt. FixList in der Version | |
12.10.xC5 |
![]() |
12.10.xC5.W1 |
![]() |