The Silent SQL Bug : When An Invalid Column Name Doesn’t Throw an error

TL;DR: SQL Server may silently convert an invalid column in a subquery into a correlated reference, meaning your query runs without errors…