userhujiong commented on issue #19906:
URL:
https://github.com/apache/shardingsphere/issues/19906#issuecomment-1207515101
> Hi @userhujiong, can you provide your sharding configuration in markdown?
I will try to reproduce this exception.
config
```yaml
spring:
shardingsphere:
props:
sql-show: true
datasource:
common:
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.cj.jdbc.Driver
initial-size: 6
min-idle: 3
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
#validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
maxPoolPreparedStatementPerConnectionSize: 20
filters: stat,wall,slf4j
connectionProperties:
druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000
wall:
multi-statement-allow: true
names: master
master:
driverClassName: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
url:
jdbc:mysql://localhost:3306/ga_app_attendance?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai
password: root
username: root
rules:
sql_translator:
type: NATIVE
sharding:
binding-tables:
- ga_app_attendance,ga_app_attendance_department
tables:
ga_app_attendance:
actual-data-nodes:
master.ga_app_attendance_2022_0$->{1..8},master.ga_app_attendance_2021_0$->{1..8}
table-strategy:
standard:
sharding-column: checkin_sharding
sharding-algorithm-name: attendance-table-inline
ga_app_attendance_department:
actual-data-nodes:
master.ga_app_attendance_department_2022_0$->{1..8},master.ga_app_attendance_department_2021_0$->{1..8}
table-strategy:
standard:
sharding-column: checkin_sharding
sharding-algorithm-name: attendance_dept_table-inline
sharding-algorithms:
attendance-table-inline:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName:
com.jrsoft.ga.business.attendance.config.MonthStandardAlgorithm
attendance_dept_table-inline:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName:
com.jrsoft.ga.business.attendance.config.MonthStandardAlgorithm
```
This problem occurs when there are two expressions
master.ga_app_attendance_2022_0$->{1..8},master.ga_app_attendance_2021_0$->{1..8}
`false`
master.ga_app_attendance_2022_0$->{1..8} `true`
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
