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

No column suggestion for CTE with row value constructor

Example using SQL Server 2008 supported Standard SQL syntax:

WITH T AS (SELECT * FROM (VALUES (1)) AS T (c))
SELECT * FROM T WHERE T

...then type a dot and I would expect the first suggestion to be the column name `c` but it is not shown as a suggestion at all.

Out of interest, it does appear when using this equivalent proprietary syntax:

WITH T AS (SELECT 1 AS c) SELECT * FROM T;
jamieuka
0

Comments

3 comments

Sort by
  • Anu D
    Many thanks for your post and apologies for inconvenience caused.

    I was able to replicate the issue and have escalated to our dev team.

    I will update this post as soon as I have more information on this.
    Anu D
    0
  • jamieuka
    One year on, any news on the status of this bug? Thanks.
    jamieuka
    0
  • blitzd
    Feature requests and improvements to functionality are not something RedGate seems to be very good at.
    blitzd
    0

Add comment

Please sign in to leave a comment.