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

• 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)

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

datatype, dependent, CR797489, CR#797489,  797489, dump , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed