SAP Knowledge Base Article - Preview

2060382 - ALL or ANY condition on date column crashes the server - SAP IQ

Symptom

  • Query with ALL/ANY condition on date column crashes the server.
  • The following functions are included in the stacktrace:

dfp_CompareAnyAll::ExecuteSubquery
dfp_CompareAnyAll::Evaluate
dfpEvaluate
s_dpByteFetch::DFPMatchDistincts
hs_dp::DFPMatchDistincts
dfp::EstimateSelectivityViaDFP
dfp::EstimateCompareSelectivity
dfp::EstimateLocalSelectivity
opt_BaseTableLeaf::EstimateTableCardinality
opt_TableNode::GatherLeafMetaData
opt_QueryTree::ProcessQueryTree
opt_Select::GenerateDFOs
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
pdfo_Scan::DoFirstFetch

Note: The complete stacktrace is attached to this document.


Read more...

Environment

SAP IQ 15.4 ESD 4.2

Product

SAP Sybase IQ 15.4

Keywords

Date, dfp_CompareAnyAll, ExecuteSubquery , dfpEvaluate,  st_server.cxx, CR771956, 771956 , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.