2 Replies Latest reply on Oct 2, 2017 3:39 PM by Jim 13131

    Strange formatting with Boolean connectors and parenthesis

    Jim 13131

      I noticed this today on a large query form one of my products reports and SQL Dev 17.2. Here is a simple query to show the issue.

       

      SQL Developer 17.2, Line Breaks > On Boolean connectors = Before

       

      Sample Query:

       

      select * from dual where (1=1) and (2=2) and (3=3) order by 1;

       

      Formatting gives:

       

      SELECT *

      FROM dual

      WHERE ( 1 = 1

        ) AND ( 2 = 2

        ) AND ( 3 = 3

        )

      ORDER BY 1;

       

      What I expect:

       

      SELECT *

      FROM dual

      WHERE ( 1 = 1 )

        AND ( 2 = 2 )

        AND ( 3 = 3 )

      ORDER BY 1;

       

      My Format settings:

       

       

      Thanks, Jim