SAP Knowledge Base Article - Preview

3069880 - Wrong results from query when statement cache and deferred name resolution are enabled - SAP ASE

Symptom

Wrong results occur when the following is true:

  • Statement cache is configured non-zero
  • deferred name resolution is enabled
  • A self-referencing update clause, using a mixture of fully qualified name of the same table. For example
    update db.owner.tablename set col=x from tablename


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP04

spelling

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR825039, CR#825039, 825039, query wrong results, def name resolution , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.