JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

[BUG] JSQLParser 5.4 SNAPSHOT : Oracle : Outer join case with NVL

Open mantesap opened this issue 5 months ago • 0 comments

Failing SQL Feature:

  • Oracle supports outer joins with (+) notation and can be used in conjunction with nvl or coalesce
  • Example: The following example cannot be parsed

SQL Example:

  • Simplified Query Example
     SELECT * FROM dual d, dual d2 where d.dummy = nvl(d2.dummy (+),'y')
    

Software Information:

  • JSqlParser version 5.4-SNAPSHOT
  • Database: Oracle

mantesap avatar Oct 22 '25 12:10 mantesap