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 09:42:12 UTC
[GitHub] [shardingsphere] lmandy opened a new issue, #25170: When using version 5.12 to query the left join table, the routing failed.
lmandy opened a new issue, #25170:
URL: https://github.com/apache/shardingsphere/issues/25170
The SQL statement is as follows, where two tables are binding relationships:
--------------------------------------------------------------------------------------
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'
--------------------------------------------------------------------------------------
The current version is 5.12, and I have checked the latest version, which also has this problem.
I looked at the source code because the tableNames attribute in the TablesContext class is of type HashSet, causing the order of the tables to change
![image](https://user-images.githubusercontent.com/16572623/232008418-5af70148-29a4-4a87-bc9c-d8d98a0500c7.png)
--------------------------------------------------------------------------------------
The version I used before was 4.1.1, but it has been solved in this version.
![image](https://user-images.githubusercontent.com/16572623/232008822-2c8d64e2-cbe3-46c2-8e75-57b5b9acfcf8.png)
I found the previous related 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] lmandy commented on issue #25170: When using version 5.12 to query the left join table, the routing failed.
Posted by "lmandy (via GitHub)" <gi...@apache.org>.
lmandy commented on issue #25170:
URL: https://github.com/apache/shardingsphere/issues/25170#issuecomment-1510635810
Yes, I'd love to.
--
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] RaigorJiang commented on issue #25170: When using version 5.12 to query the left join table, the routing failed.
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #25170:
URL: https://github.com/apache/shardingsphere/issues/25170#issuecomment-1510622555
Hi @lmandy ,
Are you interested in fixing this issue?
--
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