Skip to content

G-3120 False positive when using cursor parameters in select list #55

@PhilippSalvisberg

Description

@PhilippSalvisberg

Here's a simplified example of a real customer case:

declare
   cursor c_test(p_increase in integer) is
      select e.ename,
             d.dname,
             e.sal + p_increase as increased_sal
        from emp e
        join dept d 
          on emp.deptno = dept.deptno;
begin
   null;
end;
/

On line 5, a Missing table alias for p_increase warning is reported.

Image

Cursor parameter should be handled the same way as function and procedure parameters, since it is not possible to apply a table alias.

Metadata

Metadata

Labels

Core ValidatorUploaded to the Repo and part of the configurationbugSomething isn't working

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions