added testcases for mysql functions