Indent problem with new release and * expand

MikeyC

Given this code:

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

SELECT 
  *<cursor>
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.)

Anu D

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.

MikeyC

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

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.