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/05/21 03:21:39 UTC

[GitHub] [shardingsphere] ThanoshanMV opened a new issue, #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

ThanoshanMV opened a new issue, #17844:
URL: https://github.com/apache/shardingsphere/issues/17844

   This issue is to solve unsupported PostgreSQL statements listed below for the Shardingsphere parser.
   
   ## Background
   The ShardingSphere parser engine can handle various SQL dialects such as MySQL, PostgreSQL, SQLServer, openGauss, and Oracle. Although the parser engine supports numerous PostgreSQL statements, some important PostgreSQL statements that start with ‘c’ requires assistance in parsing and getting the SQLStatement (Java object). Therefore, this issue aims to support those specific PostgreSQL statements listed below for the ShardingSphere parser.
   
   ### Subtasks
   
   - [ ] CALL
   - [ ] CHECKPOINT
   - [ ] CLOSE
   - [ ] CLUSTER
   - [ ] COMMENT
   - [ ] COPY
   - [ ] CREATE ACCESS METHOD
   - [ ] CREATE AGGREGATE
   - [ ] CREATE CAST
   - [ ] CREATE COLLATION
   - [ ] CREATE EVENT TRIGGER
   - [ ] CREATE FOREIGN DATA WRAPPER
   - [ ] CREATE FOREIGN TABLE
   - [ ] CREATE GROUP
   - [ ] CREATE MATERIALIZED VIEW
   - [ ] CREATE OPERATOR
   - [ ] CREATE POLICY
   - [ ] CREATE PUBLICATION
   
   Reference: please refer to PostgreSQL SQL commands [documentation](https://www.postgresql.org/docs/current/sql-commands.html).


-- 
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] strongduanmu commented on issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

strongduanmu commented on issue #17844:
URL: https://github.com/apache/shardingsphere/issues/17844#issuecomment-1236059890

   All subtasks has been finished, so I will close 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] ThanoshanMV commented on issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

ThanoshanMV commented on issue #17844:
URL: https://github.com/apache/shardingsphere/issues/17844#issuecomment-1236046312

   Thank you @strongduanmu 


-- 
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 commented on issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

strongduanmu commented on issue #17844:
URL: https://github.com/apache/shardingsphere/issues/17844#issuecomment-1235989164

   Yes, another contributor @chakkk309  in the ShardingSphere community has completed the optimization of these statements, so you only need to mark it complete.


-- 
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] ThanoshanMV commented on issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

ThanoshanMV commented on issue #17844:
URL: https://github.com/apache/shardingsphere/issues/17844#issuecomment-1140199001

   We have planned to support other PostgreSQL cursor statements as well. They are Declare, Fetch and Move statements.


-- 
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] ThanoshanMV commented on issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

ThanoshanMV commented on issue #17844:
URL: https://github.com/apache/shardingsphere/issues/17844#issuecomment-1235699025

   Hi @strongduanmu, I checked the statements `DECLARE`, `FETCH`, and `MOVE`. I think now they are visited. Do we need to change anything to these statements?


-- 
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 #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

strongduanmu closed issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser
URL: https://github.com/apache/shardingsphere/issues/17844


-- 
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] ThanoshanMV commented on issue #17844: [GSoC 2022] Solve Unsupported PostgreSQL Statements That Start With 'c' for Shardingsphere Parser

Posted by GitBox <gi...@apache.org>.

ThanoshanMV commented on issue #17844:
URL: https://github.com/apache/shardingsphere/issues/17844#issuecomment-1256944724

   Thank you @strongduanmu, @tristaZero and my other mentors. 😃 🎉 


-- 
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