Skip to content

Describe foreign keys referring to the same space #3043

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
Tracked by #3543
TarantoolBot opened this issue Jul 21, 2022 · 1 comment · Fixed by #3583
Closed
Tracked by #3543

Describe foreign keys referring to the same space #3043

TarantoolBot opened this issue Jul 21, 2022 · 1 comment · Fixed by #3583
Assignees
Labels
2.11 2.11 release and the associated technical debt add details [nature] More details needed, some info missing. Documentation is incomplete. reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality

Comments

@TarantoolBot
Copy link
Collaborator

TarantoolBot commented Jul 21, 2022

Since: 2.11.0-rc1
Root documents:
https://www.tarantool.io/en/doc/latest/book/box/data_model/#constraints
https://www.tarantool.io/en/doc/latest/reference/reference_lua/box_schema/func_create/ (?)
https://www.tarantool.io/en/doc/latest/reference/reference_lua/box_space/

Details

The Constraints and Foreign keys parts in the Data model section combine a high-level explanation and a how-to guide. However, the specific parameters are not mentioned there. It's also not the best place to describe individual parameters and how to use them.
So we need to update the reference, which has no mention of constraint parameters yet:

Mention in the Data model > Constraints/Foreign keys sections that referring to self is also possible.

See also this detailed internal plan for restructuring Tarantool docs.


It is possible to create a foreign key that refers to the same space (a
child space equals to the parent space).
To do that, omit space in the foreign_key parameter, or set it to
the id or to the name of the current space.
Requested by @Gumix in tarantool/tarantool@f21f8e9.

@patiencedaur patiencedaur added 2.11 2.11 release and the associated technical debt 2sp reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality add details [nature] More details needed, some info missing. Documentation is incomplete. labels Jul 23, 2022
@patiencedaur patiencedaur added this to the Estimate [@patiencedaur] milestone Jul 23, 2022
@patiencedaur patiencedaur added 3sp and removed 2sp labels Jul 23, 2022
@locker locker added 2.10 and removed 2.11 2.11 release and the associated technical debt labels Jul 25, 2022
@locker
Copy link
Member

locker commented Jul 25, 2022

Changed 2.11 to 2.10, because I cherry-picked tarantool/tarantool@f21f8e9 to 2.10.

@patiencedaur patiencedaur removed this from the Estimate [@patiencedaur] milestone Jul 28, 2022
@veod32 veod32 removed the 3sp label Dec 9, 2022
@veod32 veod32 added 2.11 2.11 release and the associated technical debt and removed 2.10 labels Mar 6, 2023
@p7nov p7nov self-assigned this Jul 14, 2023
p7nov added a commit that referenced this issue Jul 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
2.11 2.11 release and the associated technical debt add details [nature] More details needed, some info missing. Documentation is incomplete. reference [location] Tarantool manual, Reference part server [area] Task relates to Tarantool's server (core) functionality
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants