[SVN-4358] Svn WC 1.8 upgrade from 1.7 - wrong schema

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.8.x
• Fix Version/s: 1.10-consider
• Component/s: libsvn_wc
• Assignee: Unassigned
• Reporter: Julian Foad
• Created: 22/Apr/13 16:49
• Updated: 16/Feb/15 02:55

Description

A fresh 1.8.x WC (pre-release, compiled Apr 19 2013) has a different schema from
a WC created by 1.7.8 and upgraded by the same 1.8 build.  (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);