Add join table reference check in JOIN ON clause when the columns are specified without table name or alias

[rmarduga]

Often times, while specifying the joining condition in JOIN ON clause, users make mistakes and not referencing the joining table along side with other table in join condition that result in performance issue due to conditional join resulting in CROSS JOIN.

#17333 partially addresses this issue by analyzing the queries that in JOIN ON condition specify the columns with the table directly (via table name or alias) and showing the user PERFORMANCE_WARNING if the conditional join resulted in a CROSS JOIN. However, it does not cover the cases when JOIN ON condition specifies the columns without referencing the table as in the examples below.

1. SELECT * FROM table1 LEFT JOIN table2 ON a=b
2. SELECT * FROM table1 LEFT JOIN (SELECT * FROM table2) ON a=b

[kaikalur]

#17333 is good for giving really precise error messages for copy/paste cases. We can do a more comprehensive check in the planner to make sure there are no cross joins - for example when we change a left/right/inner join a cross join we can give a warning saying we are creating a cross join due to bad join conditions.

[rmarduga]

The issue was fixed by #18041