Symptom
A simple query (which is using "IS" condition) failed to execute due to an internal error(dflib/df_Heap.cxx:1416).
[Query]
SELECT "pk", "c1", "c2"
FROM Test_TB
WHERE (( "c1" <= "c2" ) AND ("c1" != "c2" ) IS NOT TRUE ) IS TRUE
[Error]
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at dflib/df_Heap.cxx:1416 on thread 5655 (TID 3)
** Error detected for expression: ((T11.c1 <= T11.c2) AND (NOT(((T11.c1 <> T11.c2) IS TRUE)))) (qb:0, addr:0x134bae6e8)
...
...
***************** This is the STACKTRACE ***************
...
...
.df_Heap::AddToHeap(df_Evaluable*,unsigned int)+0x1454()
.df_Heap::AddToHeap(opt_QueryExp*)+0xac()
.df_Heap::CreateDFPNode(void*,opt_QueryExp*)+0x25c()
.df_Heap::GenerateDF(void*,opt_QueryExp*)+0x370()
.opt_QueryTree::AttachQueryNodesRestrictions(opt_QueryNode*,QueryNode*,a_plist_node*)+0x98()
.opt_QueryTree::CreateNextQueryNode(opt_QueryNode*,QueryNode*)+0x4f0()
.opt_QueryTree::CreateNextQueryNode(opt_QueryNode*,QueryNode*)+0x4c0()
.opt_QueryTree::CreateQueryTree(QueryNode*)+0x300()
.opt_Select::GenerateDFEs(df_Heap*,opt_QueryExp*)+0x13c()
...
...
Exception Thrown from dflib/df_Heap.cxx:1416, Err# 0, tid 3 origtid 3
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
[20238]: IQ Internal error. Please report this to Sybase IQ support.
Read more...
Environment
SAP IQ 12.7 all, 15.4 all, less than 16sp08
Product
Keywords
IS TRUE, IS NOT TRUE, CR735108, df_Heap.cxx, internal error, Non-Fatal, CR 735108, 735108, CR #735108, AddToHeap , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Bug Filed
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.
SAP Knowledge Base Article - Preview