Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

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

[Feature request] ALTER REL TABLE GROUP: Add FROM ... TO ... statement #2922

Closed
sapalli2989 opened this issue Feb 21, 2024 · 1 comment
Closed
Labels
feature New features or missing components of existing features

Comments

@sapalli2989
Copy link
Contributor

sapalli2989 commented Feb 21, 2024

It would be nice, if we could add additional node table pairs via FROM ... TO after creation of a REL TABLE GROUP relationship table. For example you need to alter database schema in the course of app progress. Or imagine an app, that allows structured, user-generated content via some kind of plugin system. This requires users to create additional tables. These tables might need to have relations to other tables. Some of these relations might have been instantiated via REL TABLE GROUP. Vice versa, same goes for DROP. Currently there is no ALTER in combination with manipulation of FROM ... TO afterwards. At least I couldn't find it in below resources:

https://kuzudb.com/docusaurus/cypher/data-definition/create-table#create-rel-table-group
https://kuzudb.com/docusaurus/cypher/data-definition/alter/

@sapalli2989
Copy link
Contributor Author

One more clarification: Given

CREATE REL TABLE GROUP Knows (FROM User To User, FROM User to City, year INT64);

What I'd like to have is an ALTER command to ADD or DROP relations from Knows at some point later on, similar to

ALTER REL TABLE GROUP Knows ADD FROM Person TO Person;
ALTER REL TABLE GROUP Knows DROP FROM User TO User;

@prrao87 prrao87 added the feature New features or missing components of existing features label Feb 21, 2024
@kuzudb kuzudb locked and limited conversation to collaborators Feb 22, 2024
@prrao87 prrao87 converted this issue into discussion #2929 Feb 22, 2024

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Labels
feature New features or missing components of existing features
Projects
None yet
Development

No branches or pull requests

2 participants