Failed to hit the sub table field “LEFT JOIN” bug

[NoodLiu]

tableA contains 1000 records

Query: SELECT * FROM tableA a LEFT JOIN tableB b ON a.id = b.id
Returns 1000 records

However, when using partitioned tables:

Query: SELECT * FROM tableA a LEFT JOIN tableB_2021 b ON a.id = b.id
Returns 1000 records

Query: SELECT * FROM tableA a LEFT JOIN tableB_2022 b ON a.id = b.id
Returns 1000 records

The final combined result becomes 2000 records. How can we make the partitioned query results match the original query result?

[terrymanu]

What is your version?

[NoodLiu]

This issue can also occur when using the latest version

What is your version?

[terrymanu]

Please clearly provide your version details.
Since this issue may not be addressed immediately, we need to ensure all information remains accurate when it's eventually fixed.

[NoodLiu]

Please clearly provide your version details. Since this issue may not be addressed immediately, we need to ensure all information remains accurate when it's eventually fixed.

5.5.2