[ https://issues.apache.org/jira/browse/DRILL-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua reassigned DRILL-5883: ----------------------------------- Assignee: Pritesh Maker > Support escape syntax for an outer join > --------------------------------------- > > Key: DRILL-5883 > URL: https://issues.apache.org/jira/browse/DRILL-5883 > Project: Apache Drill > Issue Type: New Feature > Components: Client - JDBC, Client - ODBC, SQL Parser, Storage - JDBC > Affects Versions: 1.10.0 > Environment: OS: Windows 7 32-bit > Reporting tools: Crystal Reports 2008, Crystal Reports 2016 > Reporter: second88 > Assignee: Pritesh Maker > Fix For: Future > > > Referring to section 13.4.3 of > [JSR-000221|http://download.oracle.com/otndocs/jcp/jdbc-4_2-mrel2-spec/index.html], > please add support of escape syntax for an outer join. > e.g., > {code:sql} > SELECT `A`.`ID`, `B`.`ID` > FROM {oj `dfs.tmp`.`A` `A` LEFT OUTER JOIN `dfs.tmp`.`B` `B` ON > `A`.`ID`=`B`.`ID`} > {code} > Crystal Reports 2008 & 2016 use this escape syntax in their generated SQL > statement for generic JDBC / ODBC drivers. -- This message was sent by Atlassian JIRA (v6.4.14#64029)