When using version 5.12 to query the left join table, the routing failed.

[lmandy]

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

The version I used before was 4.1.1, but it has been solved in this version.

I found the previous related issues #866

[RaigorJiang]

Hi @lmandy ,
Are you interested in fixing this issue?

[lmandy]

Yes, I'd love to.