SAP Knowledge Base Article - Preview

1942370 - Select query crashed IQ at dfp::EstimateCompareSelectivity - SAP IQ

Symptom

  • After apply IQ 15.4 ESD#3.9 a selet query invoving union and derived table failed and crashed IQ at routine dfp:EstimateCompareSelectivity().
  • IQ raises a stacktrace which contains the following functions:

.dfp::EstimateCompareSelectivity
.dfp::EstimateLocalSelectivity
.opt_TableNode::ComputeOutputCardinality
.opt_BaseTableLeaf::GenerateDFOs
.opt_TableNode::GenerateDFOs
.opt_QueryTree::GenerateDFOTree
.opt_QueryTree::ProcessQueryTree
.opt_Select::GenerateDFOs
.opt_Driver::GenerateTree
.st_cursorIQtoSA::Parse
.df_OpenCursor::Parse
.st_command::DoCmdThroughResourceGate
.st_iqdml::OpenCursor

Note: Attached to this document is the full Stack trace.


Read more...

Environment

SAP IQ 15.4 ESD#3.9

Product

SAP Sybase IQ 15.4

Keywords

CR749556, 749556, opt_TableNode, opt_QueryTree, st_cursorIQtoSA, opt_Driver, st_iqdml , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.