[plsql] WITH clause is ignored for SELECT INTO statements

[lbovet]

Affects PMD Version:

7.0.0-rc4

Description:

The AST dump ignores the WITH clause and it's content.

it outputs

<Statement CanonicalImage='' Image=''>
    <UnlabelledStatement CanonicalImage='' Image=''>
        <SqlStatement CanonicalImage='' Image='' Type=''>
            <Skip2NextTerminator CanonicalImage='' Image='' />
        </SqlStatement>
    </UnlabelledStatement>
</Statement>

for (snipped) input :

CREATE OR REPLACE PACKAGE BODY test_pack
IS
    FUNCTION get_name(p_id number) RETURN string
        IS
            l_name     string;
    BEGIN

       -- snip
        WITH base AS
                (SELECT id person_id, name person_name
                 FROM persons)
        SELECT person_name
        INTO l_name
        FROM base
        WHERE person_id = p_id;
       -- snap

        RETURN l_name;
    END get_name;
END test_pack;

Steps to reproduce:

Generate ast from above input

Running PMD through:

CLI