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