Beautifier: align alias does not work with DECODE or CASE

[Scott Eli]

The beautifier will align my column alias fine until I add a DECODE or CASE line to the SQL.

without DECODE

select subscriber_id as sub_id
      ,first_name    as sub_first
      ,last_name     as sub_last
  from subscrib

adding a DECODE

select subscriber_id as sub_id
      ,first_name as sub_first
      ,last_name as sub_last
      ,DECODE(MI, 'A', 1, 0) as middle_initial
  from subscrib

Is this is expected behavior?

 

[Marco Kalter]

This is indeed a known restriction. Alignment will only work if you use plain column names. As soon as complex expressions are used, the alignment will no longer be applied.