Fix delete and scanner behavior.

- skip rows where configured scan yields an empty Result.
 - fix concurrent modification error (removing while iterating through)