Fix the issue the SQL request built by QuickSearchBox is not handled properly by Sqlite3.
SELECT history._id AS _id, history.url AS url,
CASE WHEN bookmarks.title IS NOT NULL THEN bookmarks.title ELSE
history.title END AS title,
CASE WHEN bookmarks.url IS NOT NULL THEN "2130837532" ELSE
"2130837548" END,
history.date AS date FROM history
LEFT OUTER JOIN bookmarks ON history.url = bookmarks.url
WHERE (url LIKE ?) AND (deleted=0 AND folder=0) ORDER BY
history.date DESC
has to be replaced with:
SELECT history._id AS _id, history.url AS url,
CASE WHEN bookmarks.title IS NOT NULL THEN bookmarks.title ELSE
history.title END AS title,
CASE WHEN bookmarks.url IS NOT NULL THEN "2130837532" ELSE
"2130837548" END,
history.date AS date FROM history
LEFT OUTER JOIN bookmarks ON history.url = bookmarks.url
WHERE (bookmarks.url LIKE ?) AND (deleted=0 AND folder=0) ORDER BY
history.date DESC
Change-Id: Ib9fc03c2e102cca83c09168f75f2911a191af5ae
Author: Jean-Christophe PINCE <jean-christophe.pince@intel.com>
Signed-off-by: Xiaokang Qin <xiaokang.qin@intel.com>
Signed-off-by: Bruce Beare <bruce.j.beare@intel.com>
Signed-off-by: Jack Ren <jack.ren@intel.com>
Author-tracking-BZ: 43188
2 files changed