UNION ALL and "Right aligned to statement" option

PioL

When editing formatting style, in Statements => Data (DML) => Clauses section there is an option called "Clause alignment" which I set to "Right aligned to statement".

It works fine except when a statement has the UNION ALL opreator in which case the UNION ALL is shifted one character to the left causing the visual flow of the query to break slightly:



Is there any way to get this UNION ALL statement shifted right by 1 character by the auto-formatter?

Dan B

Hi PioL,

Thanks for posting on the Redgate forums. I have asked the team to investigate this and will provide an update as soon as possible.

Dan B

Hi PioL,

This has been raised as a bug with internal reference  SP-7603. I will provide a further update on this when I get it.