We have a bucket having 50k records with one missing attribute. Then we tried executing an update query like below.
select count(*) from my-bucket
where orderType is missing; --50k records
update my-bucket
set orderType = “MY_ORDER” where orderType is missing; – mutation = 49950
After this, when we again try to find the missing records again and again, the count keeps on increasing.
select count( * ) from my-bucket
where orderType is missing; --100 records
select count( * ) from my-bucket
where orderType is missing; --200 records
select count( * ) from my-bucket
where orderType is missing; --350 records
I am not sure what is happening.