Supported `JOIN` type keyword combinations
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 72/100
- Issue type
- Documentation
- Clarity
- Mostly clear
- Activity status
- Active
- Tech stack
- sql
- Domain
- documentation
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.
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.
- Dominant language
- CSS
- Stars
- 15
- Forks
- 49
- Avg merge
- 1d 13h
- Merged PRs (30d)
- 3
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.
More from tarantool/doc
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Difficulty 1/5 Under an hour Newbie friendliness 75/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
Similar issues
-
user-reported
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
Kong/developer.konghq.com#7316 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
HarperFast/skills#96 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
infinispan/infinispan#18150 ·
-
bug triage:deciding
Difficulty 1/5 Under an hour Newbie friendliness 88/100
open-telemetry/otel-arrow#4132 ·
-
Ecosystem: ClawMetry — the Qwen Code reader is now free and open source (follow-up to #9294 / #9338) Opencategory/integration priority/P3 scope/documentation status/ready-for-human type/feature-request
Difficulty 1/5 Under an hour Newbie friendliness 84/100