Inphoo opened a new issue #13532:
URL: https://github.com/apache/shardingsphere/issues/13532
**Version**: shardingsphere-jdbc-core-spring-boot-starter:5.0.0
I encountered an error. When inserting a record .
The following is the configuration information. I use ‘id’,'plat_code'
columns as sharding-columns
```
rules:
sharding:
sharding-algorithms:
order-database-inline:
props:
algorithm-expression: ds$->{id % 1}
type: INLINE
order-table-inline:
props:
algorithm-expression: demo_order_$->{plat_code}$->{id % 2}
type: INLINE
tables:
demo_order:
actual-data-nodes: ds0.demo_order_$->{['app','web']}$->{0..1}
database-strategy:
standard:
sharding-algorithm-name: order-database-inline
sharding-column: id
table-strategy:
complex:
sharding-algorithm-name: order-table-inline
sharding-columns: id, plat_code
```
when insert a record
```
### Error updating database. Cause: java.lang.IllegalStateException: Insert
statement does not support sharding table routing to multiple data nodes.
### The error may involve
com.epean.trade.demo.dao.mapper.DemoOrderMapper.insertSelective-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO demo_order ( id,plat_code,order_time ) VALUES( ?,?,? )
### Cause: java.lang.IllegalStateException: Insert statement does not
support sharding table routing to multiple data nodes.] with root cause
java.lang.IllegalStateException: Insert statement does not support sharding
table routing to multiple data nodes.
at
com.google.common.base.Preconditions.checkState(Preconditions.java:508)
~[guava-30.0-jre.jar:na]
at
org.apache.shardingsphere.sharding.route.engine.validator.dml.impl.ShardingInsertStatementValidator.postValidate(ShardingInsertStatementValidator.java:105)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.lambda$createRouteContext$1(ShardingSQLRouter.java:57)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at java.util.Optional.ifPresent(Optional.java:159) ~[na:1.8.0_171]
```
When I use single sharding column, there is no problem
```
# this is ok
rules:
sharding:
sharding-algorithms:
order-database-inline:
props:
algorithm-expression: ds$->{id % 1}
type: INLINE
order-table-inline:
props:
algorithm-expression: demo_order_->{id % 2}
type: INLINE
tables:
demo_order:
actual-data-nodes: ds0.demo_order_$->{0..1}
database-strategy:
standard:
sharding-algorithm-name: order-database-inline
sharding-column: id
table-strategy:
standard:
sharding-algorithm-name: order-table-inline
sharding-column: id
```
--
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]
