2401499 - materialized computed columns may corrupt alter table query - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2401499 - materialized computed columns may corrupt alter table query - SAP ASE

Symptom

  • Table with a materialized computed column
  • column with update and modify statement may get corrupted
  • 1> select * from t1
    col1              col2     col3      CC
    ---------------- -------- -------- --------
                    1        2       42       42   <-- value of CC should be 44.

    (1 row affected)

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

update, alter table, modify, materialized, column, CR747507, CR#747507, 747507 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.