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
SAP Adaptive Server Enterprise 16.0
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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.