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

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

[plsql] Parse Exception with OUTER/INNER Joins · Issue #1509 · pmd/pmd · GitHub

Affects PMD Version: 6.10.0-SNAPSHOT

Code Sample demonstrating the issue:

BEGIN

SELECT times.time_id, product, quantity
  INTO r_record
  FROM inventory 
     FULL OUTER JOIN times ON (times.time_id = inventory.time_id) 
     ORDER BY  2,1;


SELECT a
  INTO b
  FROM c tablealias
  INNER JOIN ( SELECT e FROM f )
;


END;
/

Exceptions:

net.sourceforge.pmd.lang.plsql.ast.ParseException: Encountered " "OUTER" "OUTER "" at line 6, column 11.
Was expecting one of:
    ";" ...
    "," ...
    "FETCH" ...
    "GROUP" ...
    "OFFSET" ...
    "ORDER" ...
    "WHERE" ...
    
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.generateParseException(PLSQLParser.java:53972)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.jj_consume_token(PLSQLParser.java:53823)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.UnlabelledStatement(PLSQLParser.java:15265)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Statement(PLSQLParser.java:15980)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Block(PLSQLParser.java:848)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Global(PLSQLParser.java:497)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Input(PLSQLParser.java:194)


net.sourceforge.pmd.lang.plsql.ast.ParseException: Encountered " "INNER" "INNER "" at line 13, column 3.
Was expecting one of:
    ";" ...
    "," ...
    "FETCH" ...
    "GROUP" ...
    "OFFSET" ...
    "ORDER" ...
    "WHERE" ...
    
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.generateParseException(PLSQLParser.java:53972)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.jj_consume_token(PLSQLParser.java:53823)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.UnlabelledStatement(PLSQLParser.java:15265)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Statement(PLSQLParser.java:15980)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Block(PLSQLParser.java:848)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Global(PLSQLParser.java:497)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Input(PLSQLParser.java:194)

Running PMD through: Designer

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