Beautifier Bug ver 8.0

[Victorious]

The statement

Select *
From Employer e
Join Person p
On p.Emp_ID = e.Emp_ID
Join Staff s
On s.Person_ID = p.Person_ID

must be formatted as

Select *
From Employer e
Join Person p On p.Emp_ID = e.Emp_ID
Join Staff s On s.Person_ID = p.Person_ID

In 7.1.5 it was so.

Thanks

 

[Marco Kalter]

We'll check it out.

 

[chlp]

This issue was already raised but not resolved during beta phase. The original v7 formatting was more readable. I have resorted to NoFormat Start/End comments around JOIN SQLs in PL/SQL code, which is not very convenient, to say the least.

Furthermore, SQL or code formatting should not be changed in fundamental ways between one version and another, especially when these changes are not announced in the change log. And, in any case, new options should be added to the beautifier preferences to allow users to choose between old/new formats, rather than forcing all users to use the new format.

Thanks.

 

[spasblitz]

Any word on this Marco?

 

[Marco Kalter]

Formatting of joins has indeed changed. We're looking into adding an option in the rules.