JOIN query ignores WHERE filter and returns all rows

[qianheng-aws]

Issue

SQL JOIN queries are not respecting WHERE clause filters. All rows from the joined tables are returned regardless of the filter condition.

Steps to reproduce

SELECT * FROM orders o JOIN customers c ON o.customer_id = c.id WHERE c.country = 'US'

Returns customers from all countries, not just US.

Expected

Only rows matching the WHERE condition should be in the result set.

Environment

OpenSearch 2.17, SQL plugin 2.17.0

[qianheng-aws]

test