Indent problem with new release and * expand

Given this code:

SELECT
  1 AS Field1,
  2 AS Field2,
  3 AS Field3
INTO #Test;

SELECT 
  *&lt;cursor&gt;
FROM #Test;

If you hit TAB you end up with:

SELECT 
  Field1,
    Field2,
    Field3
FROM #Test;

when I expect:

SELECT
  Field1,
  Field2,
  Field3
FROM #Test;

(It happens with real tables as well.)

MikeyC September 02, 2009 15:37

3 comments

Many thanks for your post and apologies for the inconvenience caused by this issue.

I was able to replicate the issue and have raised this as a bug (SP-2796) so that our developers will look into this and fix it in our future release.

Thanks for your patience with this issue.

Anu D September 03, 2009 07:04

0
I can't believe you didn't get around to fixing this in 4.0.3... Any ideas when the next update will be? (And it appears that this issue has gotten assigned at least two IDs: SP-2796 and SP-2838)

MikeyC November 20, 2009 13:05

0
It appears from what I have heard that Red Gate doesn't think this issue impacts many people, and it isn't slated to be fixed in version 5 that they are working on now. If you experience this bug and would like to see it fixed speak up now so that maybe they will add it to their list to fix.

MikeyC April 06, 2010 11:53

0

Please sign in to leave a comment.

How can we help you today?