Could you help to confirm if this is a formatting bug?

ogrishman

I have a piece of code:

DECLARE @orders TABLE(order_id BIGINT NOT NULL UNIQUE WITH(IGNORE_DUP_KEY=ON))

When I format it, it changed to:

DECLARE @orders TABLE (   order_idBIGINTNOTNULL
                              UNIQUE
                              WITH (IGNORE_DUP_KEY = ON)
                      );

Note the order_id and its type connected together. Can anyone help me to confirm please? I'm using the most recent version of SSMS and SQL Prompt.

Dan B

Hi ogrishman,

Thanks for posting on the Redgate forums.

Can you check if you have the 'Use new formatting styles' option selected? You can check this via SQL Prompt>Options>Experimental Features then the bottom tickbox is 'Use new formatting styles'.

If you have this turned on can you turn it off and test again?

ogrishman

Yes it was checked. When I disable the new formatting, I can format the code correctly and it was formatted to:

DECLARE @orders TABLE
    (
      order_id BIGINT NOT NULL
                      UNIQUE WITH ( IGNORE_DUP_KEY = ON )
    );

When I switch back to new formatting, it still format the code as I mentioned before.

Harry Frankish

Hi ogrishman

Thanks for reporting the issue. Yes, this is a bug in the new formatting feature. We've reproduced it here and can start working on a fix.

Many thanks
Harry

Dan B

Hi ogrishman,

Thanks for your patience with this. We have fixed this bug in SQL Prompt version 8 which can be downloaded from here

ftp://support.red-gate.com/patches/SQLPrompt/24May2017/