Beautifier Changes Code

[ghyland]

PL/SQL Developer V5.1.0.657
I had the following code with an in-line view in a SQL Window. I selected the code and requested beautification. The code was changed in functionality as opposed to form.

SELECT
TFAC.teaching_faculty_code,
TFAC.teaching_faculty,
AOU.aou_code,
AOU.aou_name,
D.academic_year
FROM academic_organisational_units AOU,
teaching_faculties TFAC,
(
SELECT DISTINCT D.aou_aou_code, D.academic_year
FROM feu_department_units FDU, departments D
WHERE D.department_code = FDU.dep_department_code
AND D.academic_year = FDU.YEAR
AND D.academic_year >= 2001
AND D.academic_year

 

[Marco Kalter]

Can you let me know what the functional change is?

Note that the PL/SQL Beautifier always performs a self-check, and if anything but spaces, returns and tabs are different, it raises an error message and does not reformat your code.

------------------
Marco Kalter
Allround Automations

 

[ghyland]

The functional change is:

SELECT tfac.teaching_faculty_code,
tfac.teaching_faculty,
aou.aou_code,
aou.aou_name,
d.academic_year
FROM academic_organisational_units aou,
teaching_faculties tfac,
(SELECT DISTINCT d.aou_aou_code, d.academic_year
FROM feu_department_units fdu, departments d
WHERE d.department_code = fdu.dep_department_code AND
d.academic_year = fdu.YEAR AND d.academic_year >= 2001 AND
d.academic_year