[BUG] JSQLParser 5.4-SNAPSHOT : Oracle : outer join operator (+) after LIKE / SIMILAR TO operand

[fudianchn]

AI disclosure: this issue was prepared with AI coding agents, reviewed and revised line by line by me.

Failing SQL Feature:

• The Oracle old-style outer join operator (+) cannot be attached to the right-hand operand of a LIKE condition. The same holds for NOT LIKE and SIMILAR TO.
• (+) already works on =, <, and other comparison operators, and on BETWEEN operands since fix(parser): parse Oracle outer join operator (+) on BETWEEN operands (#672) #2564 (issue parse error between with oracle outer join(+) #672). The consumption points in Condition, RegularConditionRHS and Between do not cover the right operand of LikeExpression / SimilarToExpression.

SQL Example:

SELECT * FROM table1 t1, table2 t2 WHERE t1.col1 LIKE t2.col2(+)

net.sf.jsqlparser.parser.ParseException: Encountered: <OPENING_BRACKET> / "("

The same failure occurs for NOT LIKE t2.col2(+), SIMILAR TO t2.col2(+), and when an ESCAPE clause follows (LIKE t2.col2(+) ESCAPE '\').

Attaching (+) to the left operand (t1.col1(+) LIKE t2.col2) already parses fine, only the right operand is missing.

Software Information:

• JSqlParser version: 5.4-SNAPSHOT (master 7cc86386)
• Database: Oracle

Tips:

• Oracle allows (+) on a column of a LIKE predicate: the documented restrictions for the (+) operator name the OR logical operator, the IN comparison condition, subqueries, self-joins and non-column expressions, but not LIKE (see the rules and restrictions list in https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/Joins.html). Typical usage is a filter on the outer-joined table such as dept.dname(+) LIKE 'SALES%', or a column-to-column pattern such as the example above.
• Grammar-wise this looks like the same family as parse error between with oracle outer join(+) #672 / fix(parser): parse Oracle outer join operator (+) on BETWEEN operands (#672) #2564: an optional LOOKAHEAD("(" "+" ")") consumption block after rightExpression = SimpleExpression() in LikeExpression and SimilarToExpression, marking the column via setOldOracleJoinSyntax, would mirror the Between fix.