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