SQL WHERE clause not applied when using INNER JOIN

[qianheng-aws]

Bug

INNER JOIN queries ignore the WHERE condition completely.

SELECT * FROM products p INNER JOIN categories c ON p.cat_id = c.id WHERE c.name = 'Electronics'

Returns products from all categories. The WHERE filter has no effect.

OpenSearch 2.17, SQL plugin 2.17.0