launchpad-reviewers team mailing list archive

[Guruprasad <mp+474461@xxxxxxxxxxxxxxxxxx>]

Guruprasad has proposed merging ~lgp171188/launchpad:add-git-repository-url-rock-recipe into launchpad:db-devel.

Commit message:
Fix a typo in the constraint

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~lgp171188/launchpad/+git/launchpad/+merge/474461
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~lgp171188/launchpad:add-git-repository-url-rock-recipe into launchpad:db-devel.

diff --git a/database/schema/patch-2211-28-3.sql b/database/schema/patch-2211-28-3.sql
index dcaa1db..04c277e 100644
--- a/database/schema/patch-2211-28-3.sql
+++ b/database/schema/patch-2211-28-3.sql
@@ -7,7 +7,7 @@ ALTER TABLE RockRecipe
     ADD COLUMN git_repository_url text,
     DROP CONSTRAINT consistent_git_ref,
     ADD CONSTRAINT consistent_git_ref CHECK (((git_repository IS NULL) AND (git_repository_url IS NULL)) = (git_path IS NULL)),
-    ADD CONSTRAINT (null_count(ARRAY[git_repository, octet_length(git_repository_url)]) >= 1)
+    ADD CONSTRAINT consistent_vcs CHECK (null_count(ARRAY[git_repository, octet_length(git_repository_url)]) >= 1),
     ADD CONSTRAINT valid_git_repository_url CHECK (valid_absolute_url(git_repository_url));
 
 COMMENT ON COLUMN RockRecipe.git_repository_url IS 'A URL to a Git repository with a branch containing a rock recipe.';