[OFBIZ-836] Bug in SqlJdbcUtil.java regarding outer join in oracle theta join mode

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: framework
• Sprint: Bug Crush Event - 21/2/2015
• Assignee: Unassigned
• Reporter: Mamdouh Kaadan
• Created: 22/Mar/07 09:33
• Updated: 26/Feb/15 19:34

Description

There is a problem in SqlJdbcUtil.java class regarding outer join in oracle, becase the sould be in the end of the Left/Right hand not in the first

The following line (number: 344):
if (isOracleStyle && viewLink.isRelOptional()) whereString.append(" ");

Should be placed after the following lines:
whereString.append(viewLink.getRelEntityAlias());
whereString.append(".");
whereString.append(filterColName(relLinkField.getColName()));

as the patch in the attached file