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
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.