Can't delete saturated values

We recently saw an issue where values from t1 (INT UNSIGNED) were copied to t2 (INT). This caused data saturation for values above 2147483647, as expected.

The unexpected behavior came from trying to delete values that were subject to data saturation. A SELECT query showed the correct number of rows with the saturated value:

SELECT COUNT(*) FROM t2 WHERE id=2147483647;

+------------+

| COUNT(*)   |

+------------+

| 2973342087 |

+------------+

But the DELETE statement couldn't find the same rows:

DELETE FROM t2 WHERE id = 2147483647;

Query OK, 0 rows affected (5.925 sec)

We also tried explicitly casting `id` as SIGNED or UNSIGNED in the DELETE statement, but there was no effect. In the end, the table had to be rebuilt from scratch because the saturated values couldn't be removed. If there's a workaround for this issue, we couldn't find it in the Columnstore documentation.