2818837 - SELECT with some data values fails on .opt_JoinNode::GenerateDFOs - SAP IQ

• 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

CR819748; CR#819748; 819748; opt_JoinNode::GenerateDFOs; .opt_QueryTree::GenerateDFOTree; opt_QueryTree::GenerateDFOTree; "SQLCode: -1006000" ; -1006000 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed