[
https://issues.apache.org/jira/browse/DERBY-4370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen reassigned DERBY-4370:
-----------------------------------------
Assignee: Knut Anders Hatlen
> Implement JOIN ... USING syntax
> -------------------------------
>
> Key: DERBY-4370
> URL: https://issues.apache.org/jira/browse/DERBY-4370
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Assignee: Knut Anders Hatlen
> Priority: Minor
> Attachments: using.diff, using_v2.diff, using_v2.stat
>
>
> The SQL standard defines two ways to specify the join condition in an INNER
> JOIN or a (LEFT/RIGHT/FULL) OUTER JOIN: with an ON clause or with a USING
> clause. Derby currently only accepts joins with an ON clause. Internally,
> Derby has code that supports USING. This code should be enabled to ease the
> migration to Derby. We must also verify that the implementation adheres to
> the standard before we enable it.
> Since USING is already a reserved keyword in Derby's parser, enabling the
> USING syntax should not cause any compatibility issues for existing queries.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
