Additional Columns Listed in "Press TAB to expand wildcards"

JoshRoss

WITH some_dumb_data AS (

SELECT id,SUM(items)/pack_size AS foo
FROM (VALUES(1,1,1)) v(id,items,pack_size)
GROUP BY id,v.pack_size

)

SELECT *
FROM some_dumb_data

if I tab after the *, I get pack_size in the column list, although it is not in the CTE.

SilentKnight61

I am experiencing something similar except it is duplicating a column when the wildcard is expanded in a SELECT * statement.