unit tests for mysql adapter