revised mysql adapter test