3612337 - Using DATEPART function in a WHERE clause fails when the date part "mo" is used instead of "month" - SAP IQ

• SELECT fails when the WHERE clause has the datepart function.
• In this datepart function, the date part "mo" is specified instead of "month".
  
  Example of SELECT:
  select * from t_datepart where datepart(mo, asof_date) = 5;

• This non-fatal stack trace below is generated.
• The SELECT is failing in dfp_Simple::SupportedDatepart while it is being parsed.
  
  dfp_Simple::SupportedDatepart
  dfp::GetEfficiencyClass
  dfp::GetUsefullnessValue
  opt_BaseTableLeaf::BuildMainTopDFPTree
  opt_BaseTableLeaf::BuildTopDFPTree
  opt_BaseTableLeaf::PrepareTop
  opt_TableNode::PrepareTop
  opt_QueryExp::PrepareAndExecTops
  opt_Driver::OptimizeQueryExp
  opt_Driver::GenerateTree
  st_cursorIQtoSA::Parse
  
  Exception Thrown from dflib/dfp_Simple.cxx:846, Err# 0, tid 13963033
  O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
  IQ Internal error. Please report this to SAP IQ support.
  -- (dflib/dfp_Simple.cxx 846)

SAP IQ 16.1

dfp_Simple::SupportedDatepart, st_cursorIQtoSA::Parse,  , KBA , BC-SYB-IQ , Sybase IQ , Problem