Symptom
An IQ server got aborted due to a simple query below.
select now(*)
from OWNER001.TAB001
order by COL001;
[Stacktrace]
Dump all thread stacks at st_server.cxx:1442 for PID: 8585270
...
.vp_OrderedProjection::Prepare()
.vp_Cursor::PrepareProjection
.dfo_VerticalLeafCursor::PrepareProjection()
.dfo_VerticalLeafCursor::PrepareChildrenAndProjection()
.dfo_VerticalLeafCursor::PrepareOpus()
.dfo::PrepareChildren()
.dfo::PrepareOpus()
If the order by clause is commented out, the crash does not happen.
select now(*)
from OWNER001.TAB001
-- order by COL001;
The same crash doesn't happen in IQ 16.0.
Read more...
Environment
SAP IQ 15.4 ESD5.11
Product
Keywords
IQ, crash, vp_OrderedProjection, vp_OrderedProjection::Prepare, CR 798778, 798778 , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview