|
Problem IT35210
|
Status: Closed |
QUERY CONTAINING CORRELATED SUBQUERY RUNNING WITH PDQ CAN AF WITH "(((VOID *)SEQSCAN->SS_RSAMINFO) == OPENP->OP_RSAMSCAN)"
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
A select containing a correlated subquery which is running with
PDQ can AF with
09:50:19 Assert Failed: (((void *)seqscan->ss_rsaminfo) ==
OPENP->op_rsamscan)
Stack:
0x0000000000f52b3e (oninit) rsseqscan_read
0x00000000014f47c0 (oninit) fmseqscan_read
0x00000000007e847e (oninit) readseq_batch
0x00000000007f6de3 (oninit) gettupl
0x00000000007faa64 (oninit) scan_next
0x000000000080149f (oninit) getrow
0x0000000000802311 (oninit) doopen
0x000000000087a8db (oninit) doopen_allany
0x000000000087ce86 (oninit) subqcmp
0x000000000164e076 (oninit) ev_anyall
0x000000000164d63e (oninit) new_eval
0x00000000007f396b (oninit) readidx_new
0x00000000007f7de4 (oninit) gettupl
0x00000000007faa64 (oninit) scan_next
0x0000000000b5dd7d (oninit) join_next
Query may fail with
244: Could not do a physical-order read to fetch next row.
101: ISAM error: file is not open.
or
769: Internal - iterator execution/phase error in NEXT. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC6 (when available). *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC6 (when available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.12.2020
18.05.2021
18.05.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
