Comments - I want to help MariaDB community and execute Test Cases and provide results how can I do that?
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
"Creating test cases" generally means one of three things.
1) Writing totally new tests and running them.
The main result of this activity is bug reports that you submit, describing the bugs that your tests found, and offering a way to reproduce these bugs reliably. If that's what you want to do, the same comment above is true for you: choose the component(s) that you want to test, choose tools that you want to use, run tests, optionally describe what you are doing in JIRA, submit bug reports in JIRA.
2) Writing test cases for previously encountered bugs which don't have a known reliable way to reproduce them.
Quite often people file bugs saying "I observed this or that, but I have no idea how to repeat it". Finding a way to reproduce such bugs is a very useful activity, although not an easy thing to do. If that's what you want to do, monitor JIRA or other internet sources where people complain about problems, when you notice such complaints, try to reproduce them, and file a bug report with the test case or update one that is already filed.
3) Writing test cases for bugfixes.
While in previous two options you can choose your own tools, this one is mainly the MTR activity.
Generally, every bug fix in MariaDB or MySQL should come with a regression test case. Unfortunately, it is a common situation nowadays that MySQL bugfixes come without public test cases. Creating test cases for them is an extremely useful activity which the community could benefit from, but it requires very deep understanding of the code; certain bzr skills; knowledge of MTR; some mind-reading capabilities are also a plus. If you feel it's something you are up to, pick up MySQL source tree, check the history, find bugfixes which do not have any test cases; and try to create a test case which fails before the bug fix, but passes afterwards. If you manage to do it, file a JIRA report for MariaDB saying that you created a test case for this or that revision and attach your test case.