|
Problem IT31106
|
Status: Closed |
It should not be possible to drop a row type that is being referenced in a stored procedure.
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The database server does not check for dependent stored
procedures while dropping a row type and will allow the row type
to be dropped. A subsequent run of that SPL will fail with a
relevant error when the row type is encountered. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when *
* available). *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when *
* available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. However, the
fix is disabled by default. To enable the fix:
1) query current server SQL_DEF_CTRL value
> select * from sysmaster:sysconfig where
cf_name='SQL_DEF_CTRL';
cf_id 262
cf_name SQL_DEF_CTRL
cf_flags 50368576
cf_original
cf_effective 0x44004b0
cf_default 0x44004b0
2) turn on bit 0x8000000; in this case that would be 0xc4004b0,
then set it with onmode:
onmode -wm SQL_DEF_CTRL=0xc4004b0 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.11.2019
28.02.2020
28.02.2020 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC14,
14.10.xC4
|
| Problem solved according to the fixlist(s) of the following version(s) |
