Masking policy: Comply with the scale and precision of a column¶

The runtime behavior of a masking policy and the masked output in terms of the scale and precision of a column is as follows:

Before the change:

The masked value as specified in the body of the masking policy does not respect the precision and scale of a column.

After the change:

If you create a new masking policy after enabling the 2024_04 behavior change bundle, set the masking policy on a column, and query the protected column, the following occurs:

• The query fails when the masked value is greater than the precision of the column.

• The masked value is truncated to the scale of the column when the scale of the masked value is greater than the scale of the column.

Ref: 1355