|
Problem IT33046
|
Status: Closed |
ISTAR QUERY WITH DECRYPT_CHAR PREDICATE PROMOTED TO THE REMOTE SERVER CAUSE AF IN DECRYPT_CONST_PASSWORD
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
In an select using remote parts where a predicate with a
DECRYPT_CHAR clause is used
and this predicate is promoted to the remote server by the
optimizer, the server may report
an af file with the following stack
x00000000008d71aa (/opt/informix/12.10.FC12/bin/oninit)
decrypt_const_password
0x000000000091aff3 (/opt/informix/12.10.FC12/bin/oninit) wrtexpr
0x000000000091b181 (/opt/informix/12.10.FC12/bin/oninit) wrtexpr
0x000000000091d0cf (/opt/informix/12.10.FC12/bin/oninit) wrtexpr
0x0000000000917336 (/opt/informix/12.10.FC12/bin/oninit)
creatext
0x00000000007c364c (/opt/informix/12.10.FC12/bin/oninit)
opbrstmt
0x00000000007c3950 (/opt/informix/12.10.FC12/bin/oninit)
opbldremote
0x000000000092625f (/opt/informix/12.10.FC12/bin/oninit)
bldremcmds
0x00000000007f3328 (/opt/informix/12.10.FC12/bin/oninit) sqoptim
0x00000000007fbf98 (/opt/informix/12.10.FC12/bin/oninit) opinit
0x00000000007ff1e5 (/opt/informix/12.10.FC12/bin/oninit)
op_opinit
0x00000000007f110c (/opt/informix/12.10.FC12/bin/oninit) sqoptim
0x0000000000a2bfb5 (/opt/informix/12.10.FC12/bin/oninit) sqbind
0x0000000000a45fde (/opt/informix/12.10.FC12/bin/oninit)
sq_common_bind
0x0000000000b0b011 (/opt/informix/12.10.FC12/bin/oninit) sqmain
0x000000000154ca1b (/opt/informix/12.10.FC12/bin/oninit)
spawn_thread
0x0000000001411450 (/opt/informix/12.10.FC12/bin/oninit)
th_init_initgls
0x0000000001456d88 (/opt/informix/12.10.FC12/bin/oninit) startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 11.70.xC9W2, 12.10.xC15 *
* and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 11.70.xC9W2, 12.10.xC15 (when *
* available) or 14.10.xC5. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 11.70.xC9W2, 12.10.xC15 *
* and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 11.70.xC9W2, 12.10.xC15 (when *
* available) or 14.10.xC5. *
**************************************************************** |
| Comment |
Fixed in Informix Server 11.70.xC9W2, 12.10.xC15 and 14.10.xC5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.06.2020
05.01.2021
05.01.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
