|
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) |
