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

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

[plsql] Parse Exception when functions are used with LIKE · Issue #1586 · pmd/pmd · GitHub

Affects PMD Version: 6.10.0

Description:
Stacktrace:

net.sourceforge.pmd.lang.plsql.ast.ParseException: Encountered " "LIKE" "like "" at line 8, column 31.
Was expecting one of:
    "IN" ...
    "NOT" ...
    
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.generateParseException(PLSQLParser.java:53977)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.jj_consume_token(PLSQLParser.java:53828)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.InCondition(PLSQLParser.java:11373)
	at net.sourceforge.pmd.lang.plsql.ast.PLSQLParser.Condition2(PLSQLParser.java:11092)

Code Sample demonstrating the issue:

BEGIN

select count(1) 
        into users
        from users_table 
        where userid = 1
            AND NVL(cmp_id,0) like NVL(other_cmp_id,0);

select count(1) 
        into users
        from users_table 
        where userid = 1
           AND LOWER (what) LIKE LOWER ('%' || name_in || '%');

END;
/

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