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.
SAP Knowledge Base Article - Preview