Nested JOIN produces duplicate rows in query output

[qianheng-aws]

I'm experiencing an issue where nested JOIN operations produce duplicate rows.

SELECT a.*, b.name, c.value FROM a JOIN b ON a.id = b.a_id JOIN c ON b.id = c.b_id

The output contains repeated rows. This seems like a bug in the JOIN execution logic.

Steps to reproduce:

1. Create three tables with foreign key relationships
2. Run a query with multiple JOINs
3. Observe duplicate rows in the output

Environment: OpenSearch SQL plugin latest version

[qianheng-aws]

test

[github-actions]

Possible Duplicate

Found 1 possible duplicate issue(s):

• SQL query with nested JOIN returns incorrect results #14 — SQL query with nested JOIN returns incorrect results

If this is not a duplicate:

• Add a comment on this issue, and the duplicate label will be removed automatically, or
• 👎 this comment to prevent auto-closure

Otherwise, this issue will be automatically closed in 7 days.

🤖 Generated with Claude Code

[qianheng-aws]

test