SAP Knowledge Base Article - Preview

2619053 - Getting wrong result on UPDATE by regular user when target table name includes owner name dbo.tablename -- SAP ASE

Symptom

  • Extra table scan operator on update target table exists in 'set showplan on' output
  • The query joins two tables; update target table name qualified as dbo.tablename, but table name in "from clause" does not include owner name dbo.
  • Only regular users (non-DBO / non-SA) get into this problem. DBO or SA gets expected query plan.
  • The update query may produce wrong results due to invalid query plan.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

table scan, showplan, set showplan on, non-DBA, non-SA, [owner].[table_name], update, from, from clause, wrong result, wrong results , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.