Hyrum K Wright <hyrum.wri...@wandisco.com> writes: > sqlite> select * from sqlite_master where type = 'index' and > tbl_name = 'WCROOT'; > index|sqlite_autoindex_WCROOT_1|WCROOT|8| > index|I_LOCAL_ABSPATH|WCROOT|9|CREATE UNIQUE INDEX I_LOCAL_ABSPATH > ON WCROOT (local_abspath) > > would both indicate there are two indices on the WCROOT table, though > we only define one. I believe one of these indices is due to the > UNIQUEness of the local_abspath column.
Yes, that's why I think we can delete them. However we rarely write to these tables so the overhead of having the superfluous index is negligible. There is no real need to remove them from 1.7 if people would prefer to make a more minimal change for 1.7. -- uberSVN: Apache Subversion Made Easy http://www.uberSVN.com
