A RetroSearch Logo

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

Search Query:

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

[pslql] ParseException when parsing LEFT JOIN · Issue #1879 · pmd/pmd · GitHub

Affects PMD Version: 6.15.0

Description:
I’m trying to test PMD with PLSQL and I’m getting an error when parsing

When I use LEFT JOIN it does not works fine in this format.

Code Sample demonstrating the issue:

SELECT cv.hidden
                  FROM (SELECT CONNECT_BY_ROOT dep_id dep_id, LEVEL as dep_level
                          FROM departments
                         WHERE dep_id = c.dep_id
                       CONNECT BY PRIOR dep_id = parent_dep_id
                         ORDER BY LEVEL) dep
                  LEFT JOIN config_visibility cv ON (cv.dep_id = dep.dep_id AND cv.app_id = p_app_id)
                  ORDER BY dep.dep_level;

Running PMD through: [CLI | Ant | Maven | Gradle | Designer | Other]
Running from command line with JDK 11.
pmd -d C:\pmd-bin-6.12.0\test -l plsql -R rulesets/plsql/TomKytesDespair.xml -f xml


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