You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "lmandy (via GitHub)" <gi...@apache.org> on 2023/04/14 08:31:26 UTC

[GitHub] [shardingsphere] lmandy opened a new issue, #25167: 在使用5.12版本进行 left join 联表查询时，路由失败

lmandy opened a new issue, #25167:
URL: https://github.com/apache/shardingsphere/issues/25167

   SQL语句如下，其中2个表是绑定关系：
   SELECT
   	pd.id,
   	pde.ewallet_order_id
   FROM
   	payment_dynamicaccountinfo pd
   LEFT JOIN payment_dynamicaccountinfo_extra pde ON pd.id = pde.payment_dynamicaccountinfo_id
   WHERE
   	1 = 1
   AND pd.dynamic_date >= '2023-01-01 00:00:00'
   当前使用版本是5.12，我当前最近的版本也是这个问题
   通过查看源码得到原因是因为TablesContext这个类中tableNames属性是一个HashSet类型，导致表的顺序发生了变化
   ![image](https://user-images.githubusercontent.com/16572623/231988663-eef55ddc-5c0f-40eb-819f-ae56fbebfbb3.png)
   
   之前使用的版本是4.1.1，而在4.1.1这个版本已经解决了的
   ![image](https://user-images.githubusercontent.com/16572623/231989145-bb8fa619-d500-4562-b070-01614826631c.png)
   
   我找到了之前的lssues   https://github.com/apache/shardingsphere/issues/866
   
   那这个问题是我的配置问题吗


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhaojinchao95 commented on issue #25167: 在使用5.12版本进行 left join 联表查询时，路由失败

Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 commented on issue #25167:
URL: https://github.com/apache/shardingsphere/issues/25167#issuecomment-1508222398

   @lmandy Hi, please translate your question to english and submit a new issue, i close it first.
   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] lmandy commented on issue #25167: 在使用5.12版本进行 left join 联表查询时，路由失败

Posted by "lmandy (via GitHub)" <gi...@apache.org>.
lmandy commented on issue #25167:
URL: https://github.com/apache/shardingsphere/issues/25167#issuecomment-1508226281

   OK


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhaojinchao95 closed issue #25167: 在使用5.12版本进行 left join 联表查询时，路由失败

Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 closed issue #25167: 在使用5.12版本进行 left join 联表查询时，路由失败
URL: https://github.com/apache/shardingsphere/issues/25167


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org