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/07/30 11:58:06 UTC

[GitHub] [shardingsphere] zjcnb opened a new issue, #19713: `SQL_PARSER` configuration shouldn't persist metadata node when use `ShardingSphere-JDBC` cluster mode

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

   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   
   `master` https://github.com/apache/shardingsphere/commit/a696de87196885f532b07c9a5b5c2b2bc95c8e06
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   `ShardingSphere-JDBC`
   
   ### Expected behavior
   
   `SQL_PARSER` configuration shouldn't persist metadata node when use `ShardingSphere-JDBC` cluster mode
   
   ### Actual behavior
   
   persist metadata node
   
   ```
   spring:
     shardingsphere:
       mode:
         type: Cluster
         repository:
           type: ZooKeeper
           props:
             namespace: governance_ds
             server-lists: localhost:2181
             retryIntervalMilliseconds: 500
             timeToLiveSeconds: 60
             maxRetries: 3
             operationTimeoutMilliseconds: 500
         overwrite: false
   
       dataSource:
         names: ds0, ds1
         ds0:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.cj.jdbc.Driver
           jdbcUrl: jdbc:mysql://localhost:3306/ds0?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
           username: root
           password: 123456
         ds1:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.cj.jdbc.Driver
           jdbcUrl: jdbc:mysql://localhost:3306/ds1?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
           username: root
           password: 123456
       rules:
         sharding:
           tables:
             t_order:
               actual-data-nodes: ds$->{0..1}.t_order$->{0..1}
               table-strategy:
                 standard:
                   sharding-algorithm-name: table-inline
                   sharding-column: user_id
               database-strategy:
                 standard:
                   sharding-algorithm-name: database-inline
                   sharding-column: order_id
           sharding-algorithms:
             table-inline:
               type: INLINE
               props:
                 algorithm-expression: t_order$->{user_id % 2}
             database-inline:
               type: INLINE
               props:
                 algorithm-expression: ds$->{order_id % 2}
         sql-parser:
           sql-comment-parse-enabled: true
       props:
         sql-show: true
   server:
     port: 8899
   ```
   


-- 
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] terrymanu closed issue #19713: `SQL_PARSER` configuration shouldn't persist metadata node when use `ShardingSphere-JDBC` cluster mode

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #19713: `SQL_PARSER` configuration shouldn't persist metadata node when use `ShardingSphere-JDBC` cluster mode
URL: https://github.com/apache/shardingsphere/issues/19713


-- 
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] zjcnb commented on issue #19713: `SQL_PARSER` configuration shouldn't persist metadata node when use `ShardingSphere-JDBC` cluster mode

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

   <img width="1027" alt="image" src="https://user-images.githubusercontent.com/33742097/181909861-df35a76d-fff0-4879-9816-0b2c76b46335.png">
   


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