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

Search for additional results

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