Uploaded image for project: 'Subversion'
  1. Subversion
  2. SVN-4358

Svn WC 1.8 upgrade from 1.7 - wrong schema

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.8.x
    • Fix Version/s: 1.10-consider
    • Component/s: libsvn_wc
    • Labels:
      None

      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);
      

        Attachments

        1. 1_x.x
          6 kB
          Philip Martin

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              julianfoad Julian Foad
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: