Supported `JOIN` type keyword combinations
Nobody has claimed this yet.
- Dominant language
- CSS
- Stars
- 15
- Forks
- 49
- Avg merge
- 1d 13h
- Merged PRs (30d)
- 3
Description
In Tarantool SQL, a JOIN type is defined by combining up to three
special keywords (CROSS, INNER, LEFT, NATURAL, OUTER, RIGHT)
before the JOIN operator:
- No keyword -
INNER JOIN. - One keyword:
CROSS->INNER JOIN+CROSS JOIN;INNER->INNER JOIN;LEFT->LEFT JOIN+OUTER JOIN;NATURAL->NATURAL JOIN;OUTER->OUTER JOIN;RIGHT->RIGHT JOIN+OUTER JOIN;
- Two and three keywords - union of types from previous rule.
The JOIN type cannot be both INNER and OUTER. Also, OUTER other
than LEFT/LEFT OUTER is not supported (for example, RIGHT JOIN,
RIGHT OUTER JOIN, plain OUTER JOIN, or LEFT RIGHT JOIN).
Requested by @ImeevMA in https://github.com/tarantool/tarantool/commit/990019b3afc9483396ba3ebddad9aec469dd584c.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Search the documentation for Tarantool SQL JOIN syntax and use the issue's keyword-combination list as the source. Update the relevant page to cover supported combinations and explicitly note the unsupported INNER/OUTER and RIGHT/OUTER cases; done when the documented behavior matches the request.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- documentation
- Issue type
- Documentation
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 72/100