|
Problem IT22289
|
Status: Geschlossen |
QUERY CHOOSING SKIP SCAN WOULD CRASH IN REMOTE_SCAN_CREATE() IF INVOLVING A REMOTE SUBQUERY
|
| Produkt: |
INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70 |
| Problembeschreibung: |
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-Zusammenfassung: |
|
| Local-Fix: |
- AVOID_SKIP_SCAN optimizer directive unfortunately wouldn't be
accepted,
with "This directive cannot be specifed in query with remote
table" (same for SKIP_SCAN)
- MULTI_INDEX_SCAN 0 avoids the problem (turns off SKIP SCAN
path)
- replacing subquery with a temp table ... |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Kommentar |
This APAR is a duplicate of IT27588 |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 06.09.2017
23.09.2019
08.10.2019 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
