[
https://issues.apache.org/jira/browse/DERBY-4495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen updated DERBY-4495:
--------------------------------------
Attachment: natural_preview.diff
Here's a quick attempt to add NATURAL JOIN. No sanity/error checking or tests,
but it seems to work in the simplest case, at least:
ij> select cast(schemaname as char(5)), cast(tablename as char(5))
> from sys.sysschemas natural join sys.systables where schemaname = 'APP';
1 |2
-----------
APP |T
APP |T1
APP |T2
3 rows selected
> Add NATURAL JOIN syntax
> -----------------------
>
> Key: DERBY-4495
> URL: https://issues.apache.org/jira/browse/DERBY-4495
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Knut Anders Hatlen
> Priority: Minor
> Attachments: natural_preview.diff
>
>
> It would be nice if Derby supported the NATURAL JOIN syntax (feature F401-01
> in SQL:2003).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
