Bug 1293710 - Group activity stream highlights by URL to avoid duplicates. r?ahunt
The same URL could be picked as highlight from history and from bookmarks.
MozReview-Commit-ID: 5vBHluZKfAN
--- a/mobile/android/base/java/org/mozilla/gecko/db/BrowserProvider.java
+++ b/mobile/android/base/java/org/mozilla/gecko/db/BrowserProvider.java
@@ -1193,17 +1193,20 @@ public class BrowserProvider extends Sha
"AND " + History.TITLE + " NOT NULL AND " + History.TITLE + " != '' " +
"AND " + History.IS_DELETED + " = 0 " +
// TODO: Implement block list (bug 1298783)
// TODO: Implement domain black list (bug 1298786)
// TODO: Group by host (bug 1298785)
"ORDER BY " + History.DATE_LAST_VISITED + " DESC " +
"LIMIT " + historyLimit + ")";
- final String query = "SELECT DISTINCT * FROM (" + bookmarksQuery + " UNION ALL " + historyQuery + ");";
+ final String query = "SELECT DISTINCT * " +
+ "FROM (" + bookmarksQuery + " " +
+ "UNION ALL " + historyQuery + ") " +
+ "GROUP BY " + Combined.URL + ";";
return db.rawQuery(query, null);
}
@Override
public Cursor query(Uri uri, String[] projection, String selection,
String[] selectionArgs, String sortOrder) {
final int match = URI_MATCHER.match(uri);