17.05 - Example: Executing a MERGE Update Request When Both the Target Table and the Source Table Have Row-Level Security Constraints - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
Assume that:
  • The user logged onto this session has the OVERRIDE UPDATE CONSTRAINT row-level security privilege on table_1.
  • Both table_1 and table_2 have the same set of row-level security constraints.

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;