How to get bun to really use "INNER JOIN" instead of "LEFT JOIN".

[oderwat]

I am evaluating bun for usage in one of my projects with an existing (MariaDB) database.

From the documentation I got this example:

It says it would use INNER JOIN instead of LEFT JOIN but It just uses LEFT JOIN with the IS NOT NULL clause. It will give the correct results but is it really expected to do it. If yes, I think the wording in the documentation needs to be "To simulate INNER JOIN instead of LEFT JOIN".

I also would like if I can force it to use INNER JOIN, especially if there is always a relation enforced in the database and everything else would be an error.

[vmihailenco]

If yes, I think the wording in the documentation needs to be "To simulate INNER JOIN instead of LEFT JOIN".

Your understanding is correct - I will update the docs.

I also would like if I can force it to use INNER JOIN

There is currently no way to do that. We discussed this previously, but could not find a nice way to support this.

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.

[oderwat]

This is pretty sad. We needed to write a lot of code manually in the last two years. This is missing and IMHO huge performance killer. Time to move on.