SAP Knowledge Base Article - Preview

2473040 - SAP IQ Crash when ROWID is used in query with VIEW and UNION

Symptom

Instead of reporting an error message (SQL Anywhere Error -156: Invalid expression near 'rowid'), IQ crashes with a stack trace when running a query using ROWID on a view that has a UNION clause.

**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_server.cxx:1927
*** PID: XXXXX
*** Message: caught signal 11, program abort
*** Thread: 33 (TID: 4)
**************************************************

** Error from IQ connection: SA connHandle: 1 SA connID: 20 IQ connID: 0000000020 User: DBA
** Time of error: 2017-04-25 10:06:41
** IQ Version: SAP IQ/16.0.110/10299/P/sp11.01
** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/sunspot/5.10/Generic_150400-07/sun4u
** Command status when error occured: NO COMMAND OR CURSOR ACTIVE
** Parser command text:
select "i" from "v12" where "rowid"("v12") > 1
Dump all thread stacks at stcxtlib/st_server.cxx:1927 for PID: XXXXX

Functions stack:

DumpAllThreads
hos_ABORT
SigHndlr
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
a_ptree_set*GetNewTree
a_db_cursor*MakeExternalCursor
a_db_cursor*MakeVolcanoOptimizerCursor
a_db_cursor*dbi_openselect
a_db_cursor*a_plan_cache::Open
do_open
do_cursor_execute
db__execute_any_imm
RequestProcedure::call
Context::call
Worker::call_on_stack
TopProcedure::call
Worker::spawn
EngStream::handle_ind
EngStream::execute
RQBaseItem::do_work
RequestQueue::worker_body
request_task
*UnixTask::pre_body(void*)


Read more...

Environment

  • SAP IQ 16.0 SP 11 PL01 and later

Product

SAP IQ 16.0

Keywords

rowid , 808111 ,CR-808111, CR808111, "st_server.cxx", , 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.