On Thu, Jan 2, 2025 at 2:57 PM vignesh C <vignes...@gmail.com> wrote: > > Conflict detection of truncated updates is detected as update_missing > and deleted update is detected as update_deleted. I was not sure if > truncated updates should also be detected as update_deleted, as the > document says truncate operation is "It has the same effect as an > unqualified DELETE on each table" at [1]. >
This is expected behavior because TRUNCATE would immediately reclaim space and remove all the data. So, there is no way to retain the removed row. -- With Regards, Amit Kapila.
