Beautifier and while statement condition with case

Luis

Member²
Hi

Not sure if this is a known issue, but using version 7.03 I found out that the beautifier fails when using this type of construction:

Code:
WHILE v_date < CASE WHEN a = 'M' THEN 1 else 2 END LOOP
I found out that it works well if I enclose the case statement between brackets:


Code:
WHILE v_date <
      ( CASE WHEN a = 'M' THEN 1 else 2 END )
  LOOP
Luis
 
Back
Top