SQL Queries - CAST Central Base - Queries on Objects - How to change the object status to unchanged

Purpose of Query

This query will force the analysis to consider the object as being unchanged.

Applicable CAST Version

Applicable RDBMS

Query for CSS

UPDATE dss_object_info 
SET    object_checksum = (SELECT object_checksum 
                          FROM   dss_object_info doi 
                          WHERE  doi.object_id = dss_object_info.object_id 
                                 AND doi.snapshot_id = <Previous Snapshot ID>) 
WHERE  snapshot_id = <Current Snapshot ID> 
       AND object_id = <Unchanged Object ID>

You should replace , by the snapshot id of the current snapshot, with the snapshot id of the previous snapshot and with the object id

Query result example

No result will be returned

Query result interpretation

Query for Oracle

Query for SQL server

Notes/comments

Query result example