SAP Knowledge Base Article - Preview

1951093 - SAP IQ server gets crashed due to an Insert statement using "WITH" clause with stacktrace and "signal 11" message.

Symptom

This problem happens when an INSERT statement is executed with "WITH" clause.

"WITH" clause is to define one or more common table expressions, also known as temporary views, to be used elsewhere in the remainder of the statement.

[Abort thread stack]

.hos_ABORT(...................................
.SigHndlr+0x54()
.QOG::addIfOuterReference(...................................
.QOG::FindViewColumn(...................................
.dfe_Builder::DoBuildViewColumn(...................................
.dfe_Builder::FactFun_E_VIEW_COLUMN(...................................
.dfe_FactoryStaticMethod::PreBuildAndArgs(...................................
.dfe_Factory::BuildAndArgs(dfe_Builder*,...................................
.dfe_Builder::BuildPrepExpr(...................................
.dfe_Builder::FactFun_E_DOT_REF(dfe_Builder*,...................................
.dfe_Builder::FactFun_E_DOT_REF(dfe_Builder*,...................................
.dfe_FactoryStaticMethod::PreBuildAndArgs(dfe_Builder*,...................................
.dfe_Factory::BuildAndArgs(dfe_Builder*,...................................
.dfe_Builder::BuildPrepExpr(...................................
.dfe_Builder::BuildArgs(...................................
.dfe_Factory::PreBuildAndArgs(dfe_Builder*,...................................
.dfe_FactoryPredCmp::PreBuildAndArgs(dfe_Builder*,...................................
.dfe_Factory::BuildAndArgs(dfe_Builder*,...................................
.dfe_Builder::BuildPrepExpr(...................................
.dfe_ExprBuilder::BuildFinalPrepExpr(...................................
.dfe_DFPBuilder::MakeConjunct(...................................
.DE_BuildRestricts(qog_DTB*,...................................
.qog_DTBSelect::BuildExpressions(QueryNode*,qog_OuterEdge*,...................................
.qog_DTBSelect::BuildExpressions()+...................................
.qog_Quantifier::BuildExpressions()+...................................
.qog_DTBSelect::BuildDerivedColumns()+...................................
.QOG::Build()+...................................


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16 SP01

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

with clause, CR 744246, CR 724532 , 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 ONE Support launchpad (Login required).

Search for additional results

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