[DRILL-5883] Support escape syntax for an outer join

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Fix Version/s: Future
• Component/s: Client - JDBC, Client - ODBC, SQL Parser, Storage - JDBC

Environment

OS: Windows 7 32-bit
Reporting tools: Crystal Reports 2008, Crystal Reports 2016

• Assignee: Pritesh Maker
• Reporter: second88
• Created: 17/Oct/17 02:05
• Updated: 09/Jan/18 20:55

Description

Referring to section 13.4.3 of JSR-000221, please add support of escape syntax for an outer join.

e.g.,

SELECT `A`.`ID`, `B`.`ID`
FROM   {oj `dfs.tmp`.`A` `A` LEFT OUTER JOIN `dfs.tmp`.`B` `B` ON `A`.`ID`=`B`.`ID`}

Crystal Reports 2008 & 2016 use this escape syntax in their generated SQL statement for generic JDBC / ODBC drivers.