942353 - places.sqlite: moz_inputhistory will not be deleted when erasing history

Status: RESOLVED WONTFIX

(Toolkit :: Places, defect, P3)

Description

[garrona]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0 (Beta/Release)
Build ID: 20131110004002

Steps to reproduce:

- Use sqlitemanager to view places.sqlite moz_inputhistory table.
- Table has lots of entries.
- Clear the whole history with FF.
- Look at places.sqlite moz_inputhistory table again.



Actual results:

Table still has all entries entered over the last few months.


Expected results:

They should have been deleted.
At least this is what I would expect of a menu entry that lets me remove my browser history.

Comment 1

[Loic]

It's not very adviced to open this db when Firefox is running due to possible corruption.

Comment 2

[garrona]

Just recreated the bug with a completely new profile.
You can fill the moz_inputhistory table by entering one letter in the adress bar and then you will be offered one of the several default mozilla bookmarks. Click on one and you should see that there is a new entry in the sqlite table with that letter.

http://i.imgur.com/J8LclOM.png

Comment 3

[Marco Bonardo [:mak]]

Clearing browsing history does not clear some data that is usually associated with Bookmarks. We made this decision in the past to maintain a good usability of the browser, also in cases where data is cleared on shutdown at every session.
We do the same for bookmark favicons, for example.
The fact a page is bookmarked is sufficient for any bad actor to tell that you are interested in that url, and the words associated with it are likely related to the page contents.
In the future we will provide options in the urlbar to remove entries more easily when they are unwanted.