On May 25, 2011 5:50 AM, "Stefan Sperling" <s...@elego.de> wrote: > > On Wed, May 25, 2011 at 10:12:42AM +0100, Julian Foad wrote: > > We can catch some WC DB inconsistencies as soon as they happen by adding > > SQLite "trigger" functions that fire on adding or modifying rows, and > > throw an error if some condition is not met. This is especially useful > > in the NODES table because of its complex rules. > > > > This patch is presented as a concept and not to apply as-is. It adds a > > couple of very simple checks, with which I caught the bug fixed in > > r1127069 and the test-bug fixed in r1127072. > > I would very much be in favour of adding such checks by default > if svn is compiled in maintainer mode!
That was the idea behind wc-checks.sql