Hi,
Bellow I will show examples of the 3 most anoying (at least for me
) 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