Mercurial > ~dholland > hg > swallowtail > index.cgi

diff database/schema/bugs.sql @ 54:36d91dfe017f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
use valid sql syntax, mostly from yetoo on freenode
author David A. Holland
date Sun, 10 Apr 2022 17:41:24 -0400 (2022-04-10)
parents 81851564f552
children 40f64a96481f
line wrap: on
line diff
--- a/database/schema/bugs.sql	Sat Apr 02 21:15:27 2022 -0400
+++ b/database/schema/bugs.sql	Sun Apr 10 17:41:24 2022 -0400
@@ -35,7 +35,7 @@
 	-- should be nulled.
 	timeout_date timestamp	null,
 	timeout_state text	null references states (name),
-	check (timestamp is null == timeout_state is null),
+	check ((timeout_date is null) = (timeout_state is null)),
 
 	-- intended constraint:
 	-- select * from PRs, states where PRs.state = states.name