vip-scanner icon indicating copy to clipboard operation
vip-scanner copied to clipboard

Flag JOINS that don't specify a table alias

Open nickdaugherty opened this issue 10 years ago • 0 comments

If two bits of code attempt to JOIN with the same tables without a unique alias, MySQL doesn't know which tables are which. All JOINs should have unique table aliases.

Normally added in the following filters:

posts_join
posts_join_request
posts_join_paged

We should be able to detect this with a regex.

nickdaugherty avatar Aug 04 '14 23:08 nickdaugherty