2651478 - SAP IQ - Non-Fatal IQ Internal Error at optlib/opt_QueryTree.cxx with a query that contained both an EXISTS subquery and a reference to a view within a FROM clause

A query that contained both an EXISTS subquery and a reference to a view within a FROM clause returns a Non-Fatal IQ Internal Error at optlib/opt_QueryTree.cxx.

IQ Internal error. Please report this to SAP IQ support.
--
(optlib/opt_QueryTree.cxx 10929)
SQLCODE=-1006000, ODBC 3 State="HY000"

• --.iqmsg

********************************************************
**
**       Non-Fatal IQ Internal Error Detected
**       at optlib/opt_QueryTree.cxx:10929  on thread 140608181876480 (TID 3)
**
**       Please report this to SAP IQ support
**       with the following diagnostic information,
**       and, if possible, with the user's command.
**
**  Error from IQ connection:  SA connHandle: 5  SA connID: 5  IQ connID: 0000000261  User: DBA
**  Time of error:  2018-06-01 19:07:08
**  IQ Version:  SAP IQ/16.0.110/10526/P/sp11.10
**  OS info:  IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5,  Executed on: Linux/VM02/4.8.6-300.fc25.x86_64/#1 SMP Tue Nov 1 12:36:38 UTC 2016/x86_64
**  Command status when error occured:  CURSOR ACTIVE
**  Command text: 
...

• stacktrace

pcstkwalk
ucstkgentrace
StackTraceForThisThread
df_Exception::df_Exception
df_Exception::ThrowException_0
opt_QueryTree::RecursiveSetInVariance
opt_QueryTree::ResetViewNodeAfterFlattenSubq
opt_QueryTree::FlattenExistsSubqueryBefore
opt_Select::FlattenExistsSubquery
opt_Select::AnalyzeSubQueries
opt_Driver::OptimizeQueryExp
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor+0x25
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
dfo_Scan::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetch
dfo_Root::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetchRelative
dfo_Root::FetchRelative
DB_Search_fetch
do_move_cursor
dbi_fetch
db__fetch
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
run_task_body+0x2d
UnixTask::pre_body
_fini+0x514cbae6
_fini+0x5097138b

• SAP IQ 16.0 SP11 PL10

"opt_QueryTree.cxx"; "RecursiveSetInVariance"; "ResetViewNodeAfterFlattenSubq"; "FlattenExistsSubqueryBefore"; "FlattenExistsSubquery"; "CR813582"; "813582"; "CR 813582"; "169164"; "Bug 169164"; "bugzilla 169164"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem