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

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 ONE Support launchpad (Login required).

Search for additional results

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