Symptom
- A select statement crash on .opt_JoinNode::GenerateDFOs when a WHERE clause on a date column is a BETWEEN 2 values.
- The query plan cannot be generated.
- DBCC returns no error
- The query looks like the following:
SELECT ....
FROM
T1, T2, T3
WHERE
..........
T1.COL_DATE BETWEEN ('2019-06-19 00:00:00') AND ('2019-07-08 00:00:00')
.........
- Some date values cause the select to fail with
Non-Fatal IQ Internal Error
at optlib/opt_JoinNode.cxx:1203
- With other date values, the select succeeds.
Excerpt of IQMSG
.opt_JoinNode::GenerateDFOs
.opt_QueryTree::GenerateDFOTree
.opt_QueryTree::GenerateDFOTree
.opt_QueryTree::GenerateDFOTree
.opt_QueryTree::GenerateDFOTree
.opt_QueryTree::GenerateDFOs
.opt_Select::GenerateDFOTree
.opt_Driver::GenerateTree
.st_cursorIQtoSA::Parse
.df_OpenCursor::Parse
...........
Exception Thrown from optlib/opt_JoinNode.cxx:1203, Err# 0, tid 9 origtid 9
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
IQ Internal error. Please report this to SAP IQ support.
-- (optlib/opt_JoinNode.cxx 1203)
Rbck
PostRbck
Read more...
Product
Keywords
CR819748; CR#819748; 819748; opt_JoinNode::GenerateDFOs; .opt_QueryTree::GenerateDFOTree; opt_QueryTree::GenerateDFOTree; "SQLCode: -1006000" ; -1006000 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.