3380589 - Query fails with stacktrace and error input to merge join #NN from child #MM not ordered as required -SAP IQ

Query fails with error below and stacktrace  :

 
**       Non-Fatal IQ Internal Error Detected
**       at dflib/dfo.cxx:** on thread *** (TID ***)
**       Input to merge join #NN from child #MM not ordered as required.  Key: ***
**       Error detected at DFO #MM Order By 
**       Please report this to SAP IQ support

***************** This is the STACKTRACE ***************

df_Exception::ThrowException
dfo::ValidateOutputOrdering
dfjo_MergeBase::ValidateInputOrdering
dfo_Join::ValidateDFOInputOrdering
dfo::ValidateInputOrderings
dfo_Root::Prepare
st_cursorIQtoSA::Prepare
df_OpenCursor::Prepare
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor

SAP IQ 16.1

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Product Enhancement