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 for Me (Login required).

Search for additional results

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