How to resolve problem that java.sql.SQLException: Please check your sharding conditions 'ShardingConditions(conditions=[ShardingCondition(values=[t_ent_order_item.order_id = 2], startIndex=0)], to avoid same record in table 't_ent_order_item' routing to multiple data nodes. about shardingsphere HOT 7 CLOSED

My configuration :
java.util.Properties propertiesForTEntOrderItem = new java.util.Properties();
propertiesForTEntOrderItem.setProperty("algorithm-expression", "t_ent_order_item_${order_id % 2}");
org.apache.shardingsphere.infra.algorithm.core.config.AlgorithmConfiguration algorithmConfigurationForTEntOrderItem = new org.apache.shardingsphere.infra.algorithm.core.config.AlgorithmConfiguration("INLINE", propertiesForTEntOrderItem);
stringAlgorithmConfigurationMap.put("t_ent_order_item_line", algorithmConfigurationForTEntOrderItem);

ShardingTableRuleConfiguration shardingTableRuleConfiguration = new ShardingTableRuleConfiguration("t_ent_order_item", "ds_${0..3}.t_ent_order_item_${[0, 1, 2, 3, 4, 5, 6, 7]}");
shardingTableRuleConfiguration.setKeyGenerateStrategy(new KeyGenerateStrategyConfiguration("id", "snowflake"));
shardingTableRuleConfiguration.setTableShardingStrategy(new StandardShardingStrategyConfiguration("order_id", "t_ent_order_item_line"));

from shardingsphere.

"t_ent_order_item", "ds_${0..3}.t_ent_order_item_${[0, 1, 2, 3, 4, 5, 6, 7]}",是要分 8个表 ， 算法algorithm-expression=t_ent_order_item_${order_id % 8} 必须是 order_id % 8

from shardingsphere.

我把算法表达式改成propertiesForTEntOrderItem.setProperty("algorithm-expression", "t_ent_order_item_${order_id % 8}");

from shardingsphere.

还是不行，报同样的错误

from shardingsphere.

PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO t_ent_order_item(ent_id, region_code, good_id, good_name, order_id) VALUES (?, ?, ?, ?, ?);");
preparedStatement.setInt(1, 2024);
preparedStatement.setString(2, "GD");
preparedStatement.setString(3, "abc123");
preparedStatement.setString(4, "研究ShardingSphere");
preparedStatement.setInt(5, 16);
int result = preparedStatement.executeUpdate();
System.out.println("打印插入结果->" + result);
我通过这段代码插入一条记录然后就抛出如下异常：
java.sql.SQLException: Please check your sharding conditions 'ShardingConditions(conditions=[ShardingCondition(values=[t_ent_order_item.order_id = 16], startIndex=0)], sqlStatementContext=org.apache.shardingsphere.infra.binder.context.statement.dml.InsertStatementContext@600428ad, rule=org.apache.shardingsphere.sharding.rule.ShardingRule@5342032a, subqueryContainsShardingCondition=true)' to avoid same record in table 't_ent_order_item' routing to multiple data nodes.
at org.apache.shardingsphere.infra.exception.core.external.sql.ShardingSphereSQLException.toSQLException(ShardingSphereSQLException.java:76)
at org.apache.shardingsphere.infra.exception.dialect.SQLExceptionTransformEngine.toSQLException(SQLExceptionTransformEngine.java:54)
at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.executeUpdate(ShardingSpherePreparedStatement.java:367)
at com.example.shardingsphere.ShardingsphereApplication.main(ShardingsphereApplication.java:57)

from shardingsphere.

Hi @JianfeiMa, can you modify the issue title for search friendly?

from shardingsphere.

问题原因是：
当分片表规则配置的实际数据节点是这样demo_ds_${0,1}.t_order_${[0, 1]}的时候，最终会拆分成笛卡尔乘积，所以在查询的时候会分别查询两个数据的两个表，但是当插入数据的时候就抛出以上错误，当我改成demo_ds_${0}.t_order_${[0, 1]}再次插入数据的时候就不会抛出异常了；如果要路由多个数据库的时候又该如何配置呢？

from shardingsphere.