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
SAP Adaptive Server Enterprise (ASE) 16.0 SP04
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 pageThis 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.