JSqlParser
JSqlParser copied to clipboard
[BUG] JSQLParser 5.4 SNAPSHOT : Oracle : Outer join case with NVL
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