drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "second88 (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-5883) Support escape syntax for an outer join
Date Tue, 17 Oct 2017 08:38:00 GMT

     [ 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)

Mime
View raw message