test cases added to the sqlite3 and mysql adapter test files.