SAP Knowledge Base Article - Preview

2692187 - IQ Server goes down referring to a nonexistent column - SAP IQ

Symptom

When referring to a column that does not exist in the table from nested SQL, IQ Server is stopped by SIGNAL 11.
The following SQL statement refers to Col4 which does not exist.
But SAP IQ does not output "Column 'Col4' not found" error.

SQL
-------------------------------------

SELECT Sub1.Col4 FROM (SELECT Col4 = Sub2.Col2 FROM 
    (SELECT Col2 FROM ReproTab UNION ALL SELECT 'XYZ' AS Col2 WHERE EXISTS 
        (SELECT Col3 FROM ReproTab WHERE Col4 = 'ABC')) Sub2
    ) Sub1;

Stack trace
-------------------------------------

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*, sigcontext*)
SigHndlr
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
_fini
GetNewTree(a_statement*, a_tabdef_set*, unsigned int*)
MakeExternalCursor(a_db_cursor*, an_isolation_level, a_cursor_spec*, a_statement*, unsigned int, unsigned int, unsigned int)
MakeVolcanoOptimizerCursor(IDBHeap*, a_statement*, an_isolation_level, a_cursor_spec*, unsigned int, unsigned int, PlanInfo*, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, df_InternalCursor*, dfv_HostVars**, a_set_of_row_descriptors**, a_query_diagnostics*)
MakeCursor(IDBHeap*, a_statement*, an_isolation_level, a_cursor_spec*, unsigned int, unsigned int, PlanInfo*, unsigned int, unsigned int, unsigned int, df_InternalCursor*, dfv_HostVars**, a_set_of_row_descriptors**, a_query_diagnostics*)
dbi_partialopen(IDBHeap*, a_statement*, unsigned int, a_cursor_spec*, PlanInfo*, unsigned int, unsigned int, df_InternalCursor*, a_query_diagnostics*, unsigned int)
a_plan_cache::OpenPartial(a_stmt*, a_statement*, unsigned int, a_cursor_spec*, PlanInfo*)
dbi_describe_statement(a_stmt*, unsigned short, unsigned short, a_cursor_spec*, unsigned int*)
db__describe_output(Connection*, an_sqlpres_receive*)
do_request(Worker*, an_sqlpres_receive*)
RequestProcedure::call()
Worker::spawn(Procedure*)
EngStream::handle_ind(unsigned char, unsigned int)
EngStream::execute()
RQConnItem::do_request()
RQBaseItem::do_work(Worker*)
RequestQueue::worker_body()
request_task(void*)
run_task_body
UnixTask::pre_body(void*)
_fini
_fini


Read more...

Environment

  • SAP Sybase IQ 15.2
  • SAP IQ 15.4
  • SAP IQ 16.0
  • SAP IQ 16.1 

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

SAP IQ, colmun, not found, UNION, sub query , 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.