lwtdev commented on issue #6497: URL: https://github.com/apache/shardingsphere/issues/6497#issuecomment-706474605
> @lwtdev Now, `customer.id=3` in `On Expression` is not yet supported, you can move it to whereClause, the future will support condition in `table join condition`. @jingshanglu It's works well after I move `customer.id=3` to whereClause. ```sql ShardingProxy(5.0.0.RC1)2DB2Table subqueryInLeftJoin[hasShardingKey:single]; Support:true; SQL: SELECT * FROM customer LEFT JOIN (SELECT party_id, status FROM customer_email WHERE is_deleted = 'N') email ON email.party_id = cusomter.party_id where customer.id = 3; ds_01|SELECT * FROM customer_0003 LEFT JOIN (SELECT party_id, status FROM customer_email_0003 WHERE is_deleted = 'N') email ON email.party_id = cusomter.party_id where customer_0003.id = 3| ``` ---------------------------------------------------------------- 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]
