Symptom
Simple SELECT TOP number 'string' FROM TABLE ORDER BY COLUMN could cause fatal abort on df_Table::SCIdxExistForOrderedLeaf
Excerpt of stack trace on Linux:
** Command text:
select top 2000 'a_string' from lineitem order by l_orderkey
df_Table::SCIdxExistForOrderedLeaf
vp_OrderedProjection::Prepare
vp_Cursor::PrepareProjection
dfo_VerticalLeafCursor::PrepareProjection
dfo_VerticalLeafCursor::PrepareChildrenAndProjection
dfo_VerticalLeafCursor::PrepareOpus
dfo::PrepareChildren
dfo_RowLimit::PrepareOpus
Read more...
Environment
SAP IQ 16 any SP.
This issue could be encountered on other IQ previous versions.
Product
Keywords
Select top, CR 782552, 782552, fatal abort, df_Table::SCIdxExistForOrderedLeaf, df_Table, SCIdxExistForOrderedLeaf, , 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.