Commit9edca92

authored

fix: fix incorrect migration in constraint (#19212)

1 parentdc59885 commit9edca92Copy full SHA for 9edca92

File tree

-2

lines changed

-2

lines changed

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8,13 +8,15 @@ UPDATE`
`8`	`8`	`SET`
`9`	`9`	`deadline= max_deadline`
`10`	`10`	`WHERE`
`11`		`- deadline> max_deadline`
`12`		`-AND max_deadline!='0001-01-01 00:00:00+00';`
	`11`	`+(deadline='0001-01-01 00:00:00+00'::timestamptzOR deadline> max_deadline)`
	`12`	`+AND max_deadline!='0001-01-01 00:00:00+00'::timestamptz;`
`13`	`13`
`14`	`14`	`-- Add the new constraint.`
`15`	`15`	`ALTERTABLE workspace_builds`
`16`	`16`	`ADDCONSTRAINT workspace_builds_deadline_below_max_deadline`
`17`	`17`	`CHECK (`
	`18`	`+-- (deadline is not zero AND deadline <= max_deadline)...`
`18`	`19`	`(deadline!='0001-01-01 00:00:00+00'::timestamptzAND deadline<= max_deadline)`
	`20`	`+-- UNLESS max_deadline is zero.`
`19`	`21`	`OR max_deadline='0001-01-01 00:00:00+00'::timestamptz`
`20`	`22`	`);`

Comments

(0)