How can we help you today? How can we help you today?

Additional Columns Listed in "Press TAB to expand wildcards"

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.
JoshRoss
0

Comments

1 comment

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

Add comment

Please sign in to leave a comment.