Fix delete and scanner behavior.

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