jmbkeyes edited a comment on issue #1782: how to config the datasource if I just need shard one table in one database? URL: https://github.com/apache/incubator-shardingsphere/issues/1782#issuecomment-455952181 **if there's only one same datasouce for both shard and not-shard, all sql will execute in the shard connection. And non-shard table sql will also show sharding log as below[group_booking_instance is non-shard table].** 2019-01-21 13:20:00 INFO ShardingSphere-SQL:71 - Rule Type: sharding 2019-01-21 13:20:00 INFO ShardingSphere-SQL:71 - Logic SQL: **select gs.* from group_booking_instance gs where gs.endDate in(?, ?) and gs.status = 1 and gs.endTs<now() limit ?** 2019-01-21 13:20:00 INFO ShardingSphere-SQL:71 - SQLStatement: SelectStatement(super=DQLStatement(super=io.shardingsphere.core.parsing.parser.sql.dql.select.SelectStatement@36aca72e), containStar=true, firstSelectItemStartPosition=7, selectListLastPosition=12, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.of(gs))], groupByItems=[], orderByItems=[], limit=Limit(offset=null, rowCount=LimitValue(value=100, index=2, boundOpened=false)), subQueryStatement=null, subQueryStatements=[], subQueryConditions=[]) 2019-01-21 13:20:00 INFO ShardingSphere-SQL:71 - Actual SQL: ds0 ::: select gs.* from group_booking_instance gs where gs.endDate in(?, ?) and gs.status = 1 and gs.endTs<now() limit ? ::: [[20190120, 20190121, 100]]
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services
