No column suggestion for CTE with row value constructor

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

No column suggestion for CTE with row value constructor

Postby jamieuka » Tue Jan 03, 2012 10:32 am

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
 
Posts: 4
Joined: Tue Jan 03, 2012 10:15 am

Postby Anu Deshpande » Thu Jan 05, 2012 11:54 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby jamieuka » Fri Jan 11, 2013 4:36 pm

One year on, any news on the status of this bug? Thanks.
jamieuka
 
Posts: 4
Joined: Tue Jan 03, 2012 10:15 am

Postby blitzd » Wed Jan 16, 2013 7:47 pm

Feature requests and improvements to functionality are not something RedGate seems to be very good at.
blitzd
 
Posts: 32
Joined: Fri Nov 26, 2010 7:30 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest