Skip to content
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.

Sign up for GitHub

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

Jump to bottom

[YSQL] Ensure consistency for ALTER TABLE ADD CONSTRAINT #1395

Open
ndeodhar opened this issue May 16, 2019 · 1 comment
Open

[YSQL] Ensure consistency for ALTER TABLE ADD CONSTRAINT #1395

ndeodhar opened this issue May 16, 2019 · 1 comment
Assignees
@sushantrmishra
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
YSQL Index backfill
Milestone
v2.3

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented May 16, 2019 •
edited by yugabyte-ci

Jira Link: DB-665
Currently, ALTER TABLE .. ADD CONSTRAINT is not consistent and we can have concurrency issues where there may be some rows added which violate the constraint while adding the constraint.

This is similar to index backfilling. Our solution should be generic enough to handle both these situations.
@ndeodhar ndeodhar added this to To do in YSQL via automation May 16, 2019
@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label May 16, 2019
@ndeodhar ndeodhar added this to the v2.0 milestone May 16, 2019
@amitanandaiyer amitanandaiyer added this to To do in Index backfill Mar 6, 2020
@amitanandaiyer amitanandaiyer moved this from To do/Current-Sprint to Todo/Wishlist in Index backfill Mar 9, 2020
@ndeodhar ndeodhar modified the milestones: v2.0, v2.3 Jun 5, 2020
@rkarthik007 rkarthik007 mentioned this issue Jun 5, 2020
Open
@ndeodhar ndeodhar moved this from To do to Backlog in YSQL Aug 5, 2020
@ndeodhar ndeodhar mentioned this issue Aug 7, 2020
Open
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 3, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Sep 15, 2022
@rthallamko3
Copy link
Contributor

cc @tvesely , Is this relevant in the context of the constraint check issues that you are looking at? cc @sushantrmishra

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sushantrmishra sushantrmishra

Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
Index backfill
  
Todo/Wishlist
YQL-beta
Status: No status
YSQL
  
Backlog
Milestone
v2.3
Development

No branches or pull requests
5 participants
@sushantrmishra @ndeodhar @rthallamko3 @yugabyte-ci @amitanandaiyer