The On-Disk Btree index does not delete the column value folder on an update operation, when post operation there are no more records present with the specific column value. This results in incorrect responses for SELECT DISTINCT query, which still assumes that a record with the previous value is present in the DB.