You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ndeodhar
changed the title
Non-key columns in unique index affect constraint enforcement
[YSQL] Non-key columns in unique index affect constraint enforcement
May 21, 2019
Summary:
This revision fixes an issue with the included index columns where they should be included as the
non-primary-key columns in the index.
Test Plan: yb_create_index
Reviewers: mihnea, neil, neha
Reviewed By: neha
Subscribers: srhickma, yql
Differential Revision: https://phabricator.dev.yugabyte.com/D6650
Summary: Adding INCLUDE (non-key) columns in a unique index affects the enforcement of uniqueness on the key columns. This should not be the case.
Reproduction Steps:
Expected Results: It is expected that the CREATE INDEX statement will produce an error, since there are duplicate values in
c1
.Note: If
INCLUDE (c2)
is removed, then the correct error is displayed:The text was updated successfully, but these errors were encountered: