Query considered Straddled join during plan, but not during execution

[altmannmarcelo]

Description

Check why we are considering the below query as straddled:

This uses mysql employees database - https://github.com/datacharmer/test_db

create cache from SELECT d.dept_name, COUNT(*) AS employee_count FROM dept_emp de JOIN departments d ON de.dept_no = d.dep
t_no WHERE de.to_date = '9999-01-01' GROUP BY de.dept_no;

ERROR 1105 (HY000): Error during RPC (extend_recipe): Failed to plan migration: Operation unsupported: Straddled joins are not supported

However, this is not remapping keys at domain::on_replay_misses nor is considered generated on Ingredient::Join::on_input

Change in user-visible behavior

Requires documentation change