JOIN on two same columns make server search indefintely

It was caused directly from a programming mistake, but I think that it can also be considered as a bug.

I do a mistake like this in a JOIN :

SELECT categories.*

FROM categories

JOIN products ON products.category_id = products.category_id

I don't know if it's a bug, but I think that the server should throw an error when a query try to join comparing two table/columns pairs that are the same causing the server to indefinitely run.

Thank you very much and have a great day !