Beautifier and sub-queries

[D.]

Hi,

Version 6.0.4.906

Subqueries in the WHERE clause don't seem to lining up correctly after beautifying especially if used within brackets. Could be to do with the fact that AND's and OR's do not get wrapped properly.

Here's an example ...

Orginal
-------

SELECT 'X'
FROM   dual
WHERE  ('This is a long item name' = 'This is a long item name'
OR     ('to force wrapping' = 'to force wrapping'
AND    1 = (SELECT 1
            FROM   dual)));

Beautified
----------

SELECT 'X'
FROM   dual
WHERE  ('This is a long item name' = 'This is a long item name' OR
       ('to force wrapping' = 'to force wrapping' AND 1 = (SELECT 1
                                                            FROM   dual)));

Notice the subquery FROM clause is offset from the SELECT, and the OR's and AND's are also at the end of line instead of at the start. I can send the beautifier rules file, if you need that to replicate results.

Regards,
D.

 

[Marco Kalter]

This is indeed not correct. We'll fix it.