You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "FlyingZC (via GitHub)" <gi...@apache.org> on 2023/08/02 10:02:06 UTC
[GitHub] [shardingsphere] FlyingZC opened a new issue, #27815: Support parsing openGauss CREATE sql
FlyingZC opened a new issue, #27815:
URL: https://github.com/apache/shardingsphere/issues/27815
# Background
Hi community,
ShardingSphere parser engine helps users parse a SQL to get the AST (Abstract Syntax Tree) and visit this tree to get SQLStatement (Java Object). Currently, we are planning to enhance the support for openGauss SQL parsing in ShardingSphere.
More details:
https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/
# Task
This issue is to support more openGauss sql parse, as follows:
```sql
CREATE TABLESPACE example1 RELATIVE LOCATION 'tablespace1/tablespace_1';
```
```sql
CREATE TABLESPACE example2 RELATIVE LOCATION 'tablespace2/tablespace_2';
```
```sql
CREATE TABLESPACE example3 RELATIVE LOCATION 'tablespace3/tablespace_3';
```
```sql
CREATE TABLESPACE example4 RELATIVE LOCATION 'tablespace4/tablespace_4';
```
```sql
CREATE TABLE tpcds.web_returns_p2
(
WR_RETURNED_DATE_SK INTEGER ,
WR_RETURNED_TIME_SK INTEGER ,
WR_ITEM_SK INTEGER NOT NULL,
WR_REFUNDED_CUSTOMER_SK INTEGER ,
WR_REFUNDED_CDEMO_SK INTEGER ,
WR_REFUNDED_HDEMO_SK INTEGER ,
WR_REFUNDED_ADDR_SK INTEGER ,
WR_RETURNING_CUSTOMER_SK INTEGER ,
WR_RETURNING_CDEMO_SK INTEGER ,
WR_RETURNING_HDEMO_SK INTEGER ,
WR_RETURNING_ADDR_SK INTEGER ,
WR_WEB_PAGE_SK INTEGER ,
WR_REASON_SK INTEGER ,
WR_ORDER_NUMBER BIGINT NOT NULL,
WR_RETURN_QUANTITY INTEGER ,
WR_RETURN_AMT DECIMAL(7,2) ,
WR_RETURN_TAX DECIMAL(7,2) ,
WR_RETURN_AMT_INC_TAX DECIMAL(7,2) ,
WR_FEE DECIMAL(7,2) ,
WR_RETURN_SHIP_COST DECIMAL(7,2) ,
WR_REFUNDED_CASH DECIMAL(7,2) ,
WR_REVERSED_CHARGE DECIMAL(7,2) ,
WR_ACCOUNT_CREDIT DECIMAL(7,2) ,
WR_NET_LOSS DECIMAL(7,2)
)
TABLESPACE example1
PARTITION BY RANGE(WR_RETURNED_DATE_SK)
(
PARTITION P1 VALUES LESS THAN(2450815),
PARTITION P2 VALUES LESS THAN(2451179),
PARTITION P3 VALUES LESS THAN(2451544),
PARTITION P4 VALUES LESS THAN(2451910),
PARTITION P5 VALUES LESS THAN(2452275),
PARTITION P6 VALUES LESS THAN(2452640),
PARTITION P7 VALUES LESS THAN(2453005),
PARTITION P8 VALUES LESS THAN(MAXVALUE) TABLESPACE example2
)
ENABLE ROW MOVEMENT;
--以like方式创建一个分区表。
```
# Process
1. First confirm that this is a correct openGauss sql syntax, if not please leave a message under the issue and ignore it;
2. Compare SQL definitions in Official SQL Doc and ShardingSphere SQL Doc;
3. If there is any difference in ShardingSphere SQL Doc, please correct them by referring to the Official SQL Doc;
4. Run mvn install the current_file_module;
5. Check whether there are any exceptions. If indeed, please fix them. (Especially xxxVisitor.class);
6. Add new corresponding SQL case in SQL Cases and expected parsed result in Expected Statement XML;
7. Run SQLParserParameterizedTest to make sure no exceptions.
# Relevant Skills
1. Master JAVA language
2. Have a basic understanding of Antlr `g4` file
3. Be familiar with openGauss SQLs
--
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
Re: [I] Support parsing openGauss CREATE sql [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #27815:
URL: https://github.com/apache/shardingsphere/issues/27815#issuecomment-1783911423
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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
Re: [I] Support parsing openGauss CREATE sql [shardingsphere]
Posted by "FlyingZC (via GitHub)" <gi...@apache.org>.
FlyingZC closed issue #27815: Support parsing openGauss CREATE sql
URL: https://github.com/apache/shardingsphere/issues/27815
--
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] github-actions[bot] commented on issue #27815: Support parsing openGauss CREATE sql
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #27815:
URL: https://github.com/apache/shardingsphere/issues/27815#issuecomment-1703266610
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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