apache / shardingsphere

Empowering Data Intelligence with Distributed SQL for Sharding, Scalability, and Security Across All Databases.
Apache License 2.0
19.98k stars 6.75k forks source link

[Oracle SQL] Improve compatibility with Oracle SQL #27569

Open lancelly opened 1 year ago

lancelly commented 1 year ago

Hi, community, This issue is for my OSPP project(https://summer-ospp.ac.cn/org/prodetail/235930377?list=org&navpage=org). I'm currently working on improving compatibility with Oracle SQL in ShardingSphere. There are about 50 known unsupported Oracel SQLs in ShardingSphere as listed in the OSPP project. I will refer to Offical Guide of Oracel(https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/index.html) and try to fix most of the unsupported SQLs in the next couple of months. @RaigorJiang is my mentor for the OSPP project. I'm looking forward to contribute to the community and get this work done.

lancelly commented 1 year ago

Hi, I fixed HR-5-19 in this PR: https://github.com/apache/shardingsphere/pull/27572 It is my first PR in the community. Please take a look~ @RaigorJiang

RaigorJiang commented 1 year ago

Hi @lancelly, welcome here!

lancelly commented 1 year ago

Hi, I fixed HR-5-158 in this PR: https://github.com/apache/shardingsphere/pull/27603

lancelly commented 1 year ago

Hi, I fixed HR-7-1 in this PR: https://github.com/apache/shardingsphere/pull/27604

lancelly commented 1 year ago

Hi, I fixed OE-4-6/OE-4-7/OE-4-8 in this PR: https://github.com/apache/shardingsphere/pull/27614

github-actions[bot] commented 1 year ago

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.