test: add test to cover double join errors

[Thenkei]

Definition of Done

Refer to #512

General

• [ ] Write an explicit title for the Pull Request, following Conventional Commits specification
• [ ] Test manually the implemented changes
• [ ] Validate the code quality (indentation, syntax, style, simplicity, readability)

Security

• [ ] Consider the security impact of the changes made