问题:使用ShardingShpere-JDBC的影子库,参考官方例子配置,但是运行插入(INSERT)失效
如上如下,运行了一下,发现查询没问题,但是插入却失效了!!!!
....
# 影子表关联影子算法名称列表(多个值用","隔开)
spring.shardingsphere.rules.shadow.tables.shadow_user.shadow-algorithm-names=user-id-insert-match-algorithm,user-id-select-match-algorithm
spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.type=VALUE_MATCH
spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.props.operation=insert
spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.props.column=userType
spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-insert-match-algorithm.props.value=1
spring.shardingsphere.rules.shadow.shadow-algorithms.user-id-select-match-algorithm.type=VALUE_MATCH
spring.sh