updated the test cases for mysql db