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.