You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/06 21:08:22 UTC

[GitHub] [shardingsphere] Liangda-w opened a new issue, #16621: [OpenForce 2022] Add Oracle SQL `DROP DIRECTORY`

Liangda-w opened a new issue, #16621:
URL: https://github.com/apache/shardingsphere/issues/16621

   Hi community,
   
   This issue is for [OpenForce 2022](https://github.com/apache/shardingsphere/discussions/12683#discussioncomment-2139441)
   
   ## Background
   ShardingSphere parser engine helps users parse a SQL to get the AST (Abstract Syntax Tree) and visit this tree to get SQLStatement (Java Object). At present, this parser engine can handle SQLs for `MySQL`, `PostgreSQL`, `SQLServer`, `openGauss` and `Oracle`, which means we have to understand different database dialect SQLs.
   More details: 
   https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/
   
   ## Task
   This issue is to support parsing Oracle SQL `DROP DIRECTORY`. You can learn more details about this SQL [here](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/DROP-DIRECTORY.html#GUID-3719950A-7B6A-4284-8467-B3455ECF8516).
   - Remember to add new corresponding SQL cases in [SQL Cases](https://github.com/apache/shardingsphere/tree/master/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported) and expected parsed results in [Expected Statment XML](https://github.com/apache/shardingsphere/tree/master/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case).
   - Run [SQLParserParameterizedTest](https://github.com/apache/shardingsphere/blob/master/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/engine/SQLParserParameterizedTest.java) and [UnsupportedSQLParserParameterizedTest](https://github.com/apache/shardingsphere/blob/master/shardingsphere-test/shardingsphere-parser-test/src/main/java/org/apache/shardingsphere/test/sql/parser/parameterized/engine/UnsupportedSQLParserParameterizedTest.java) to make sure no exceptions.
   
   ## Relevant Skills
   1. Master JAVA language
   2. Have a basic understanding of Antlr g4 file
   3. Be familiar with Oracle SQLs
   
   ## Targets files
   You can take a look at this PRs as a reference
   *  #14048 
   * #16024  


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] Liangda-w commented on issue #16621: [OpenForce 2022] Add Oracle SQL `DROP DIRECTORY`

Posted by GitBox <gi...@apache.org>.
Liangda-w commented on issue #16621:
URL: https://github.com/apache/shardingsphere/issues/16621#issuecomment-1091309309

   Hey @Devamparikh, thanks for your interest! But since you have #16620 already, I would assign this to @everly-gif, who asked for such issues before :)  


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] everly-gif commented on issue #16621: [OpenForce 2022] Add Oracle SQL `DROP DIRECTORY`

Posted by GitBox <gi...@apache.org>.
everly-gif commented on issue #16621:
URL: https://github.com/apache/shardingsphere/issues/16621#issuecomment-1090961405

   Hi, I would like to work on this issue !
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu closed issue #16621: [OpenForce 2022] Add Oracle SQL `DROP DIRECTORY`

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #16621: [OpenForce 2022] Add Oracle SQL `DROP DIRECTORY`
URL: https://github.com/apache/shardingsphere/issues/16621


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] Devamparikh commented on issue #16621: [OpenForce 2022] Add Oracle SQL `DROP DIRECTORY`

Posted by GitBox <gi...@apache.org>.
Devamparikh commented on issue #16621:
URL: https://github.com/apache/shardingsphere/issues/16621#issuecomment-1090849900

   Hey there! 
   I was in search for issues like this to work on.
   Can I take this issue?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org