I know parts of this are covered in other JIRA cases. But lets consolidate all that here.
The main reason for me accepting this split (especially on 3.2) is because of testsuite failures on 9i because of 9i's bad handling of complex join criteria. Oracle9iDialect will fall back to proprietary Oracle join syntax. Oracle10gDialect will use ANSI join syntax.
trunk / 3.2