0

Bug: "Use hard deletes" together with "Keep field values up-to-date"

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.

2 comments

Please sign in to leave a comment.