Add spaces around parentheses contents

torsten.strauss

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

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