Symptom
- After migrated to IQ16 SP10.8, a specific query constantly generates a Non-Fatal IQ Internal Error with optlib/opt_QueryTree.cxx.
- The problematic query had worked fine on IQ 12.7.
- This is reproducible issue with just DDL.
Excerpt of stack trace
opt_QueryTree::GenerateInferredPredicates
opt_QueryTree::GenerateInferredPredicates
opt_QueryTree::GenerateInferredPredicates
opt_QueryTree::ProcessPredicates
opt_Select::ProcessPredicates
opt_DML::ProcessPredicates
opt_Driver::OptimizeQueryExp
opt_Driver::GenerateTree
db_InsertRoot::Execute
Read more...
Environment
SAP IQ 16.0 SP10 and later
Product
SAP IQ 16.0
Keywords
CR 795897 ; CR#795897 ; 795897 ; "opt_QueryTree..InferScalarSubQuery" ; 'opt_QueryTree.cxx" ; "opt_QueryTree" ; , 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.