Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://github.com/pmd/pmd/issues/4820 below:

[plsql] WITH clause is ignored for SELECT INTO statements · Issue #4820 · pmd/pmd · GitHub

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

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4