> I just wonder when we started to rely on a particular query plan. It turns out to be more complex than that. I started bisecting to find the revision that broke trunk, and found that in r1542765, op-depth-test changed its failure mode from, e.g.,
/Users/brane/src/svn/repos/trunk/subversion/libsvn_subr/sqlite.c:313: (apr_err=SVN_ERR_SQLITE_CONSTRAINT) svn_tests: E200035: sqlite[S19]: WC DB validity check 03 failed to the current, e.g., svn_tests: E200006: expected {3, "A/B-move/C", "base-deleted", moved-to A/B-move/C-move}; found {3, "A/B-move/C", "base-deleted"} FAIL: op-depth-test 12: test_wc_move However, this does not happen with the same tests; in r1542764, op-depth-test #12 passes, but other tests fail with the constraint error. Given the above, my best guess is that these two errors are not related in any way, and that STMT_INSTALL_SCHEMA_STATISTICS is simply broken if the sqlite_stat3 or sqlite_stat4 tables are enabled and/or present. -- Brane -- Branko Čibej | Director of Subversion WANdisco // Non-Stop Data e. br...@wandisco.com