| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC15.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT37805 | Status: Closed |
SELECT FOR TABLE CONTAINING BLOBS FAILS AFTER COMPRESSED | |
| product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
| Problem description: | |
In version 14.10.FC5 over a linux box creating a table like
this:
create table "informix".tablexml
(
tcoda smallint not null ,
tcodb smallint not null ,
tcodc char(1) not null ,
tcodd integer not null ,
tcode char(1) not null ,
xml_codef text in blobdbs not null
);
create unique index "informix".ix_tablexml_01 on
"informix".tablexml
(tcodd,tcoda,tcodb,tcodc,tcode) using btree ;
create index "informix".ix_tablexml_02 on "informix".tablexml
(tcoda)
using btree ;
(blobdbs blobspace needs to be created in the instance)
After loading the rows table needs to be compressed:
execute function sysadmin:task('table
compress','tablexml','stores_demo','informix')
execute function sysadmin:task('table
repack','tablexml','stores_demo','informix')
execute function sysadmin:task('table
shrink','tablexml','stores_demo','informix')
Using a client aplication like CSDK ConnectTestDemo issue the
following statement:
select * from tablexml
where tcodd = xxxxxx | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC7. * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC7. * **************************************************************** | |
| Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC7. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.07.2021 02.11.2021 04.05.2023 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
