In FUJITSU Enterprise Postgres 12, changed to error when running an operator or function that returns non Data Types for Masking type.

FUJITSU Enterprise Postgres 11 or earlier

In the following cases, the operator or function in 3) may be executed without masking.

This is an incorrect result because the data containing the masking column is performed without masking.

1) Create a Masking policy. and

2) Execute a SELECT statement. and

3) Execute an operator or function in the SELECT statement of 2). and

4) The operator or function argument of 3) includes a subquery. and

5) The operator or function argument of 3) contains the column to be protected created in 1). and

6) The operator or function of 3) returns a type not listed in "Data Types for Masking" in "Operation Guide".

FUJITSU Enterprise Postgres 12 or later

Operator or function results of 3) in the following error.

ERROR:  The output data type is incompatible with the confidential policy.
HINT:  Data type of the result value(s) produced by expression/function using confidential columns is not supported by Data masking module. Consider removing confidential columns from such expressions/functions.

This is correct because the operator or function returns a data type not listed in "Data Types for Masking" in "Operation Guide".

Do one of the following to ensure that the results are identical to those of FUJITSU Enterprise Postgres 11 and earlier:

1) Modify the Masking policy to prevent masking from being performed for the user executing the SQL.

2) Modify SQL to not use operators or functions that return types not listed in "Data Types for Masking" in "Operation Guide".