[
https://issues.apache.org/jira/browse/DRILL-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Khatua updated DRILL-5883:
--------------------------------
Fix Version/s: Future
> 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
> 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)
