Verify the snapshot metadata for the last empty table [DBZ-3113]

Migrated from [DBZ-3113](https://issues.redhat.com/browse/DBZ-3113)

Write a test/check the code shared by all connectors to verify the behaviour when last snapshotted table is empty? Will the last record contain the snapshot flags?

MySQL connector solves this using buffered change event queue. We need to identify whether this is a wide issue and if yes then the MySQL specific solution should be pulled-up to the common code base.

Start by locating the code shared by all connectors for snapshot completion and compare it with the MySQL connector's buffered change event queue. Add a check for the final snapshotted table being empty and verify whether the last record retains the snapshot flags. Done means the behavior is verified and any broadly applicable solution is identified.

Written by the indexing model from the issue text.