Parentheses lost aligment in case/when clauses

EsioNunes

Hi.
I'm trying to format a code as the sample bellow:

select	case 1
			when 1 then
				1
			when 2 then
				(2)
			when 3 then
				3
			when 4 then
				4
			when 5 then
				5
			when 6 then
				6
		end;

So have a complex statement that requires parenthesis to be coded.

When SQL Prompts reformats my code, this happens:

select	case 1
			when 1 then
				1
			when 2 then
	(2)
			when 3 then
				3
			when 4 then
				4
			when 5 then
				5
			when 6 then
				6
		end;

Any idea?

Best regards,

Ésio

AlessandroAlpi

hi @EsioNunes,
what is the style you're using when formatting?

FabiolaB

Hi @EsioNunes ,

Thank you for reporting this issue.
I have logged a ticket for it (ref SP-6749).

Regards,
Fabiola