Beautifier Corrections

[mamv]

Hi,

Bellow I will show examples of the 3 most anoying (at least for me :grin bugs in sql beautifier I encouter almost in everyday usage. I had them stated on the beta forum, but since it was deleted I feel its my dutty to post them again.

Really hope you guys can fix this. Keep up the exellent work.

NOT EXISTS:

How it looks after beautifier:

SELECT *
  FROM services
 WHERE NOT EXISTS (SELECT NULL
          FROM ex_services);

How it should look:

SELECT *
  FROM services
 WHERE NOT EXISTS (SELECT NULL
                     FROM ex_services);

Comments in IF Statments:

How it looks after beautifier:

BEGIN
  -- comment
  IF 1 = 1 THEN
    -- comment
    NULL;
    -- comment
  ELSIF 2 = 2 THEN
    -- comment
    NULL;
    -- comment
  ELSE
    -- comment
    NULL;
  END IF;
END;

How it should look:

BEGIN
  -- comment
  IF 1 = 1 THEN
    -- comment
    NULL;
  -- comment
  ELSIF 2 = 2 THEN
    -- comment
    NULL;
  -- comment
  ELSE
    -- comment
    NULL;
  END IF;
END;

Hints on Select Statements:

How it looks after beautifier:

SELECT /*+ FIRST_ROWS */
 serviceid,
 name,
 service2servicetype
  FROM service
 WHERE service2servicetype = 1950000042;

How it should look:

SELECT /*+ FIRST_ROWS */
       serviceid,
       name,
       service2servicetype
  FROM service
 WHERE service2servicetype = 1950000042;

Kind Regards,
Manuel Vidigal

 

[Marco Kalter]

Thanks for your feedback, we'll check it out.

 

[DLGL]

Hi,

I really like the proposed formatting.

Serge