Top
Enterprise Postgres 16 SP1 Release Notes

2.2.4 Changing the display result when data masking is applied to NaN, infinity, -infinity

Incompatibility

In FUJITSU Enterprise Postgres 14, the display result when data masking is applied to NaN, infinity, and -infinity will be changed.

FUJITSU Enterprise Postgres 13 SP1 or earlier

If the float type NaN, infinity, and -infinity are partially masking with (9,1,2), the following will be displayed.

NaN : 99
Infinity : 99
-Infinity : 99
FUJITSU Enterprise Postgres 14 or later

If the float type NaN, infinity, and -infinity are partially masking with (9,1,2), the following will be displayed.

NaN : NaN
Infinity : Infinity
-Infinity : -Infinity

Action method

If the application is analyzing the SQL masking output result, please consider the non-numeric output result and correct it.