389492 - create an index over moz_places title

Status: VERIFIED FIXED

(Firefox :: Bookmarks & History, defect)

Description

[(not reading, please use [e-mail] instead)]

create an index over moz_places title

needed by bug #389491.

dietrich, can you add this to your ride-along schema changes for bug #319455?

Comment 1

[(not reading, please use [e-mail] instead)]

dietrich has this fix as part of bug #319455, which is targeted for m7.

thanks again, dietrich!

Comment 2

[Dietrich Ayala (:dietrich)]

fixed as a ride-along schema change in bug 319455.

Comment 3

[Al Billings [:abillings - ex-MoCo]]

How do we verify this fix or can it be easily verified?

Comment 4

[(not reading, please use [e-mail] instead)]

> How do we verify this fix or can it be easily verified?

verify using SQLite Database Browser.

After this fix, both an existing profile (from before this fix) and a new profile (after this fix) should create the moz_places_titleindex on the title column of the moz_places table.

Comment 5

[Tracy Walker [:tracy]]

I see "title" for the column in moz_places table.  The DB structure shows:
Name: moz_places_titleindex
Object: index
Type: <blank>
Schema: CREATE INDEX moz_places_titleindex ON moz_places (title)

so I think this is verified.

Comment 6

[Gervase Markham [:gerv]]

Bug 451915 - move Firefox/Places bugs to Firefox/Bookmarks and History. Remove all bugspam from this move by filtering for the string "places-to-b-and-h".

In Thunderbird 3.0b, you do that as follows:
Tools | Message Filters
Make sure the correct account is selected. Click "New"
Conditions: Body   contains   places-to-b-and-h
Change the action to "Delete Message".
Select "Manually Run" from the dropdown at the top.
Click OK.

Select the filter in the list, make sure "Inbox" is selected at the bottom, and click "Run Now". This should delete all the bugspam. You can then delete the filter.

Gerv