Example: Executing a MERGE Update Request When Both the Target Table and the Source Table Have Row-Level Security Constraints - Analytics Database - Teradata Vantage

The update of table_1 is valid and the database takes the constraint values for target table table_1, which are not specified in the request, from the constraint values defined for source table table_2.

     MERGE INTO table_1 AS target
     USING table_2 AS source
     ON (target.col_1 = source.col_1) 
     WHEN MATCHED THEN
     UPDATE SET level = source.col_2;