I noticed that a fresh 1.8.x (pre-release) WC has a different schema from a WC 
created by 1.7.8 and upgraded by 1.8.x.  (I haven't tried different 1.7.x 
versions.)  The differences are:


--- schema-1.7.8-upgraded-to-1.8-dev
+++ schema-1.8-dev

-   file_external  TEXT,
+   file_external  INTEGER,


-CREATE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (
-    wc_id, parent_relpath);
+CREATE UNIQUE INDEX I_ACTUAL_PARENT ON ACTUAL_NODE (
+    wc_id, parent_relpath, local_relpath);

-CREATE INDEX I_NODES_PARENT ON NODES (
-    wc_id, parent_relpath, op_depth);
+CREATE UNIQUE INDEX I_NODES_PARENT ON NODES (
+    wc_id, parent_relpath, local_relpath, op_depth);


This looks like a 1.8 release blocker.

Filed as issue #4358 <http://subversion.tigris.org/issues/show_bug.cgi?id=4358>.

- Julian


--
Join WANdisco's free daily demo sessions on Scaling Subversion for the 
Enterprise
<http://www.wandisco.com/training/webinars>

Reply via email to