What are the challenges you face when working across database platforms? Take the survey
Options

Indent problem with new release and * expand

MikeyCMikeyC Posts: 249 Bronze 3
edited April 6, 2010 11:53AM in SQL Prompt Previous Versions
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.)

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    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)
  • Options
    MikeyCMikeyC Posts: 249 Bronze 3
    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.
Sign In or Register to comment.