No column suggestion for CTE with row value constructor
jamieuka
Posts: 6
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;
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;
Comments
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.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com