Bug in beautifier formatting

MartinF

Member²
Hi,
We found a problem with formatting of beautifier when naming alias of column name with character ""

In the following exemple, the select statement is not align correctly.

SQL:
select depno as department_number
          ,dname as "department name"
           ,loc   as department_location
    from   dept
          ,emp
    where  emp.empno = p_empno
    and    dept.deptno = emp.deptno;

But if we change the setting to put the comma at the end of the line it work correctly

SQL:
select depno as department_number,
           dname as "department name",
           loc   as department_location
    from   dept,
           emp
    where  emp.empno = p_empno
    and    dept.deptno = emp.deptno;
 
Back
Top