Informix - Problem description
Problem IT32783 | Status: Closed |
UPGRADE FROM 11.70.FC9 TO 14.10.FC3 OF DATABASE WITH SPATIAL BLADE LEAVES OLD EXTERNAL NAME IN SYSPROCBODY FOR GEOMETRYEQUAL | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
The following was reported after upgrading a special build of 11.70.FC9 to 14.10.FC3 on AIX64. The problem has been reproduced on AIX64 upgrading 11.70.FC9 to 14.10.FC3. After upgrading to 14.10.FC3, there appears to be a single row in sysprocbody that has its data column set to a create function that includes an external name pointing to old spatial install. For instance: $ dbaccess stores_demo - > select * from sysprocbody a, sysprocedures b where datakey = "T" and > data matches "*spatial.8.21.FC5*" and a.procid = b.procid; procid 795 datakey T seqno 1 data create function Equal(ST_Geometry,ST_Geometry) returns boolean with (not variant, parallelizable) external name '$INFORMIXDIR/extend/spatial.8.21.FC5/spatial. bld(GeometryEqual)' language c; procname equal owner informix procid 795 mode O retsize 176 symsize 507 datasize 0 codesize 0 numargs 2 isproc f specificname externalname $INFORMIXDIR/extend/spatial.8.22.FC2/spatial.bld(GeometryEqual) paramstyle I langid 1 paramtypes st_geometry,st_geometry variant f client f handlesnulls f iterator f percallcost 0 commutator negator selfunc se_equalselectivity internal f class stack parallelizable t costfunc se_equalcost selconst 0.00 collation en_US.819 procflags 0 1 row(s) retrieved. Description | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.05.2020 06.12.2020 06.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |