2302348 - If a base table in a view is altered, a subsequent select on the view may return an incorrect result set - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2302348 - If a base table in a view is altered, a subsequent select on the view may return an incorrect result set - SAP ASE

Symptom

  • After loading a database, you modify the data type of a column of a base table which is used in a view.
  • When you run a SELECT statement on the view, the result set may become incorrect.
  • However, if you run the same SELECT statement on the view again, the result set becomes correct:

1> use testdb
2> go
1> alter table test modify b numeric(9,6)
2> go
(5 rows affected)
1> select * from v_test
2> go
 a           b
 ----------- ---------
           1     0.078
           1     0.117
           1     0.156
           1     0.195
           1     0.234

(5 rows affected)
1> select * from v_test
2> go
 a           b
 ----------- ------------
           1     0.020000
           1     0.030000
           1     0.040000
           1     0.050000
           1     0.060000

(5 rows affected)


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

datatype, dependent, CR797489, CR#797489,  797489, dump , 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 ONE Support launchpad (Login required).

Search for additional results

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