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
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.