Beautifier doesn't align aliases when "as" is used.

[Gustavo]

Hi, Marco,

Select substr(o196082.num_nota, 1, 10) As c_2,
       o196082.cod_material As e196458,
       o196082.cod_organizacao As e196465,
       o196082.data_emissao As e196564,
       o196082.data_recebimento As e196583,
       o196082.des_material As e196649,
       o196082.document_number As e196669,
       o196082.doc_fornecedor As e196670,
       o196082.invoice_id As e196748,
       o196082.nome_fornecedor As e196900,
       o196082.num_nota As e196948,
       o195871.organization_name As e197011,
       o196082.qtde_nota As e197153,
       o196082.tipo_docto As e197424,
       o196082.uf_fornecedor As e197477,
       o196082.uom_material As e197504,
       o196082.valor_total_nota As e197526
From   test_beautifier01 o195871,
       test_beautifier02 o196082
Where  ((o195871.organization_name = o196082.nome_organizacao And
       o195871.organization_id = o196082.organization_id))
And    (o195871.organization_name In
      ('XXXXXXXXXXXXXXXX', 'AAAAAAAAAAAAAAAAAAAAAA', 'CCCCCCCCCCCCCCCCCCCC',
         'WWWWWWWWWWWWW'))
And    (o196082.data_recebimento Between '01-JAN-2011' And '31-JAN-2011')

I believe the "As" keyword should be aligned when Select Align is checked in beautifier options, right?

Regards,
Gustavo

 

[Marco Kalter]

No, this is caused by the substr() expression. Items will only be aligned when they are field names.

 

[Gustavo]

Hmmmm... Is this final or will it be enhanced?

Regards,
Gustavo

 

[Marco Kalter]

This is on the list of enhancement requests, but I don't have a date yet.

 

[Gustavo]

Hi, Marco,

You mentioned somewhere that beautifier enhancements would be implemented in an upcoming 9.1 release. Will this request be included? Can we have a date for 9.1? Or, at least, a quarter?

Regards,
Gustavo

 

[Marco Kalter]

No, I don't have any concrete information yet.

 

[Gustavo]

This has not been enhanced yet...

 

[Gustavo]

Yet another pending beautifier enhancement...