Applying a filter to a column affects all result sets containing a column with that name

[Benjin]

Repro:

1. Create two tables that have a shared column name, and insert data:

CREATE TABLE FirstTable (name nvarchar(50))
INSERT INTO FirstTable values ('Albert')
INSERT INTO FirstTable values ('Benjamin')

CREATE TABLE SecondTable (name nvarchar(50))
INSERT INTO SecondTable values ('Benjamin')
INSERT INTO SecondTable values ('Charlie')

2. Select from both tables:

SELECT * FROM FirstTable
SELECT * FROM SecondTable

3. Apply a filter on the name column of the first result set

Expected:

• only the first result set's values are filtered

Reality:

• the name column is filtered in both result sets

20241216-2125-54.5891116.mp4