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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.