SAP Knowledge Base Article - Preview

2394242 - The IQ table can't sort the analytic functions of the catalog table - SAP IQ

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

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

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.