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.

* 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

* Stack :

**************************************************
*** SAP IQ Abort:
*** From: optlib/opt_JoinNode.cxx:1203
*** Rethrown from: oslib/hos_throw.cxx:316
*** PID: 45996
*** Exception Location: 0x0x7f78caaed380
*** Error ID: 9216, Exception Type: df_Exception
*** Thread: 140156773275392 (TID: 4, Original TID: 4)

===== Thread Number ....
.pcstkwalk ..
.ucstkgentrace ..
.StackTraceForThisThread ..
.df_Exception::df_Exception ..
.df_Exception::ThrowException_0 ..
.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 ..
.st_command::DoCmdThroughResourceGate ..
.st_iqdml::OpenCursor ..
.UIQDML_OpenCursor+0x4c ..
...

SAP IQ 16.1 SP 02 PL 10

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