No column suggestion for CTE with row value constructor

[jamieuka]

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;

[Anu Deshpande]

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.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

[jamieuka]

One year on, any news on the status of this bug? Thanks.

[blitzd]

Feature requests and improvements to functionality are not something RedGate seems to be very good at.