You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "second88 (JIRA)" <ji...@apache.org> on 2017/10/17 08:38:00 UTC
[jira] [Updated] (DRILL-5883) Support escape syntax for an outer
join
[ https://issues.apache.org/jira/browse/DRILL-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
second88 updated DRILL-5883:
----------------------------
Environment:
OS: Windows 7 32-bit
Reporting tools: Crystal Reports 2008, Crystal Reports 2016
Description:
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.
was:
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}
> 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
>
> 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)