You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/03/11 10:32:55 UTC
[GitHub] [incubator-shardingsphere] codefairy08 edited a comment on issue
#1908: In query route error
codefairy08 edited a comment on issue #1908: In query route error
URL: https://github.com/apache/incubator-shardingsphere/issues/1908#issuecomment-471486187
@guowdxp it compute availableTargetDatabases using sharding condition, then use each availableTargetDatabases and sharding condition value compute actual table, it cause datasource Cartesian with actual table, when database sharding column is the same as table sharding column ,it execute more actual sql, but the result is correct. StandardRoutingEngine#routeDataSources method return a Map<String,List<RouteValue>>, key is datasource name, value is this datasource RouteValues
, doSharding(availableTargetDatabases, databaseShardingValues) , split databaseShardingValues ,each databaseShardingValues with one element,StandardRoutingEngine#routeTables(final TableRule tableRule, final String routedDataSource, final List<RouteValue> tableShardingValues, Map<String,List<RouteValue>> datasourceRouteValues) ,when database sharding column is the same as table sharding column, use datasourceRouteValues compute actual tables。
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services