FDM - Lines not masked when datetime used as index

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We've noticed if a table uses a datetime column as sole unique index, FDM will not mask lines where the day of the datetime is 26

I've attached our FDM config and .sql creation script for the masked table. Normally all lines should be masked, but only 2016-06-15 17:23:22.010 and 2016-05-13 12:58:33.340 get their lines masked

Environment

Release : 4.10

Cause

It isn't about the date or the 26th day, it's actually about SQL Server precision of 3.33 milliseconds when storing DATETIME values.

Resolution

Resolved in FDM 4.10.524.0