[GitHub] KomachiSion commented on issue #1763: The correct result cannot be found when the binding table is associated with the query

[GitBox <gi...@apache.org>]

KomachiSion commented on issue #1763: The correct result cannot be found when the binding table is associated with the query
URL: https://github.com/apache/incubator-shardingsphere/issues/1763#issuecomment-455396622
 
 
   Hi @chenshao6311, I can not recurrent your problem with your description.
   I need more information.
   
   1.  Is that ShardingSphere example? if not, please provides your full ShardingSphere configuration or try to run ShardingSphere example first.
   2. Can you open `sql.show` and provide the SQLstatement and actual SQL like following:
   ```
   [INFO ] 2019-01-18 09:32:21,022 --main-- [ShardingSphere-SQL] Logic SQL: SELECT i.* FROM t_order o, t_order_item i WHERE o.order_id = i.order_id and o.order_id=?; 
   [INFO ] 2019-01-18 09:32:21,022 --main-- [ShardingSphere-SQL] SQLStatement: SelectStatement(super=DQLStatement(super=io.shardingsphere.core.parsing.parser.sql.dql.select.SelectStatement@181e72d3), containStar=true, firstSelectItemStartPosition=7, selectListLastPosition=11, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.of(i))], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null, subQueryStatements=[], subQueryConditions=[]) 
   [INFO ] 2019-01-18 09:32:21,022 --main-- [ShardingSphere-SQL] Actual SQL: ds_1 ::: SELECT i.* FROM t_order_1 o, t_order_item_1 i WHERE o.order_id = i.order_id and o.order_id=?; ::: [[292953431725834241]] 
   [INFO ] 2019-01-18 09:32:21,022 --main-- [ShardingSphere-SQL] Actual SQL: ds_0 ::: SELECT i.* FROM t_order_1 o, t_order_item_1 i WHERE o.order_id = i.order_id and o.order_id=?; ::: [[292953431725834241]]
   ```

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services