Hello,
I found a bug in TimeXtender Discovery Hub: When using both the features "Use hard deletes" and "Keep field values up-to-date", certain lines are not deleted, although they disappear in the source table.
The following code gets generated to handle the delete process:
DELETE V
FROM [dbo].[f_data] V
WHERE
NOT EXISTS (
SELECT TOP 1 1
FROM [dbo].[f_data_PK] P
WHERE
P.[id] = V.[id]
)
AND NOT EXISTS (
SELECT TOP 1 1
FROM [dbo].[f_data_R] R
WHERE
R.[id] = V.[id]
)
This works correctly without the "Keep field-values up-to-date" feature. All rows that are not in the _PK table and that are not in the _R table get deleted. But there are rows that get updated by the "Keep field-values up-to-date" and land in the _R table, although they are not in the source table. This is why they don't get deleted.
