jingshanglu commented on issue #7129: URL: https://github.com/apache/shardingsphere/issues/7129#issuecomment-693216422
> > @mark4z Can you show more stack info? > > Sorry, I can't resume it now. but actually it doesn't work. > > like this: > > Actual SQL: ds0 ::: select count(1) from forward left join back0 on back0.id = forward.id and back0.price = 100 where forward.id = 1 > Actual SQL: ds0 ::: select count(1) from forward left join back1 on back1.id = forward.id and back1.price = 100 where forward.id = 1 > > ‘back’ is a table which has been sharing and the key is 'price'. @mark4z `forward` is a actualTable? can you give the correct rewrited sql for this sql? ---------------------------------------------------------------- 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: [email protected]
