New specs to enforce adapter's API

First test highlights that `find_first` fails when it is used to find a single record with a condition on the partition key.
Second test was missing: we should check that `find_first` returns `nil` when no record could be found, as documented.