Symptom
When using RANK () or ROW_NUMBER () for catalog table, the IQ table can't sort this result.
** Error from IQ connection: SA connHandle: 3 SA connID: 4 IQ connID: 0000000062 User: DBA
** Time of error: 2016-11-09 13:36:16
** IQ Version: SAP IQ/16.0.110/10339/P/sp11.04
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/xxxxxxx/2.6.32-431.el6.x86_64/#1 SMP Sun Nov 10 22:19:54 EST 2013/x86_64
** Command status when error occured: CURSOR ACTIVE
** Command text:
select "UID" from(select "UID","ROW_NUMBER"() over(order by "UPDATE_DT" asc) as
"ORD_NUM" from "CAT_TBL") as "TMP" where "TMP"."ORD_NUM" <= (select cast('60' as
integer) from "iq_dummy") order by 1 asc
Dump all thread stacks at stcxtlib/st_server.cxx:1926 for PID: 26645
***************** This is the STACKTRACE ***************
===== Thread Number 139701922006784 (IQ connID: 0000000062) =====
pcstkwalk(stk_trace*, int, db_log*, hos_fd*)
ucstkgentrace(int, int)
DumpAllThreads(char const*, unsigned int, int)
hos_ABORT(char const*, unsigned int, char const*, char*, char*)
SigHndlr
dfo_Ranking::FetchOpus()
dfo_SubQueryFilter::FetchOpus()
dfo_cOrderBy::PrefetchAndSort()
dfo_cOrderBy::FetchOpus()
dfo_Cursor::FetchOpus()
dfo_Root::FetchOpus()
st_cursorIQtoSA::FetchRows(unsigned int)
st_cursorIQtoSA::Execute()
df_OpenCursor::Execute()
st_command::DoCmdThroughResourceGate()
st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*,a_cursor_spec*, a_cursor_orientation)
UIQDML_OpenCursor
st_SAIQInterfaceInfo::callFunction()
st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)
st_SAIQInterface::Execute(int, void*, unsigned int (*)
saint_iqthresholddml::OpenCursor(a_statement*, IConnection*,ICursor*, a_cursor_spec*, a_cursor_orientation)
df_OmniRowScan::Restart(a_cursor_orientation)
dfo_Scan::DoFetch(a_cursor_orientation)
dfo_Scan::DoFirstFetch(a_cursor_orientation)
dfo_Base::Fetch(a_cursor_orientation)
dfo_Root::DoFetch(a_cursor_orientation)
dfo_Root::DoFirstFetch(a_cursor_orientation)
dfo_Base::Fetch(a_cursor_orientation)
dfo_Root::DoFetchRelative(int, int*)
Read more...
Environment
- SAP Sybase IQ 12.x and later
- SAP IQ 15.x and later
- SAP IQ 16.0
Product
Keywords
RANK, ROW_NUMBER, CIS_OPTION, CATALOG TABLE , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.