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.