|
Problem IT27588
|
Status: Closed |
QUERY CHOOSING SKIP SCAN WOULD CRASH IN REMOTE_SCAN_CREATE() IF INVOLVING A REMOTE SUBQUERY
|
| product: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problem description: |
A query of the form
SELECT * FROM WHERE =
(SELECT FROM WHERE
);
would crash with following stack if
- choosing SKIP SCAN path for main_table and
- subq_table is a remote table residing on different server
afstack
mt_ex_throw_sig
afsig_handler
remote_scan_create
it_create
prepselect
subqprep
exsubq
geval
loadkey
loadidxkey
loadindex_bounds
pull
fill_result_buf
rmap_fetch
readmidx
gettupl
scan_next
getrow
fetchrow
exfetch
sql_nfetch
sq_nfetch
sqmain
spawn_thread
th_init_initgls
startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS 11.70.xC9 and earlier versions. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Query choosing SKIP SCAN would crash in remote_scan_create() *
* if involving a remote subquery. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.12.2018
08.10.2019
08.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
