Apache ShardingSphere — Proofread Oracle DML SQL Definitions — GSoC 2021

Contributions

As per my mentors’ suggestions, I created pull requests which consist of proofread changes and corresponding unit functions.

1. SELECT statement

As Oracle SELECT statement definition is complex and other DML statements depend on it, from the beginning I started working with it. I proofread SELECT statement via successive pull requests. Here is the list of successive pull requests I made:

2. INSERT statement

Here’s the pull request that I made to proofread Oracle INSERT statement:

3. DELETE statement

Here’s the pull request that I made to proofread Oracle DELETE statement:

4. UPDATE statement

Here’s the pull request that I made to proofread Oracle UPDATE statement:

Summary

The changes that I made will be included in the next release of Apache ShardingSphere to improve this parse engine.

Merged pull requests

Pull requests under code review

TODOs

After making changes in pull requests that are under code review, all the DML SQL definitions will be aligned with Oracle documentation. In the future, if there are any issues raised by users regarding Oracle DML SQL parsing, I’ll try to work on that as well.

Conclusion

It would be impossible to work on this project without my mentors’ support and guidance. I am grateful to my wonderful mentors Juan Pan and Guangyuan Wang. They are very friendly, flexible and have worked tirelessly to guide me. I would like to thank Apache ShardingSphere community for providing me with this wonderful opportunity.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Thanoshan MV

Thanoshan MV

My notes, findings, thoughts and investigations.