Re: Issue #4358 - Svn WC 1.8 upgrade from 1.7 - wrong schema
From: Julian Foad <julianfoad_at_btopenworld.com>
Date: Mon, 22 Apr 2013 21:09:57 +0100 (BST)
Julian Foad wrote:
Ah... but that index couldn't be used for queries that only provide a local_relpath. Although parent_relpath is a prefix of local_relpath, a plain 'local_relpath' index is ordered by lexical order where the '/' character is not special (ordering example: foo0bar, foo/bar, fooZbar), whereas the local relpaths in a (parent_relpath, local_relpath) index would be would be in a different order (foo/bar, foo0bar, fooZbar).
I wish we indexed the tables by (parent_relpath, basename) instead of duplicating the whole parent_relpath in the local_relpath column; that would make things like this easier.
Sorry for the noise.
This is an archived mail posted to the Subversion Dev mailing list.