How can we help you today? How can we help you today?

Add spaces around parentheses contents

Hi Redgate Team,

The option Parentheses / Spaces / Add spaces around parentheses contents will add spaces / tab where it shouldn't.

-- enabled
SELECT *
FROM sys.fn_dblog (NULL, NULL)
WHERE
[Transaction ID] IN ( SELECT___(tab added)[Transaction ID] FROM
sys.fn_dblog ('359:2429:26', '359:2429:26')
);
GO

-- disabled
SELECT *
FROM sys.fn_dblog (NULL, NULL)
WHERE
[Transaction ID] IN (SELECT [Transaction ID] FROM
sys.fn_dblog ('359:2429:26', '359:2429:26')
);
GO

I guess this is not intended.

BTW It would be nice to have formatting control about the subquery - it looks really bad comparing to the rest ...

Thanks!

Torsten
torsten.strauss
0

Comments

1 comment

Sort by
  • torsten.strauss
    Figured out that this will be caused by enabling Expressions / IN /Add a space around IN contents as well....
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.