Closed PhilippSalvisberg closed 5 months ago
The following query reports a G-3183. In this case it would be possible to omit the dept reference.
dept
select dept.dname, sum(emp.sal) as sal from dept join emp on emp.deptno = dept.deptno group by dept.dname;
However, in this case it's mandatory to use the table alias for deptno.
deptno
select d.deptno, d.dname, sum(e.sal) as sal from dept d join emp e on e.deptno = d.deptno group by d.deptno, d.dname;
So a qualified name should be allowed in the group by clause and not cause a G-3183.
closed via Azure DevOps commit
The following query reports a G-3183. In this case it would be possible to omit the
dept
reference.However, in this case it's mandatory to use the table alias for
deptno
.So a qualified name should be allowed in the group by clause and not cause a G-3183.