Fossil

Differences From Artifact [98a4e12627]:

• File src/search.c — part of check-in [a611ea3671] at 2015-02-03 18:10:19 on branch trunk — Make sure search-related SQL functions are registered before running the SQL statements in search_touch(). (user: drh size: 45861) [more...]

To Artifact [d8993bf13f]:

• File src/search.c — part of check-in [188c62c2d5] at 2015-02-04 03:12:18 on branch trunk — Increase the default number of tokens present in snippets from an indexed search so that a typical snippet is about two lines of text instead of just one. (user: drh size: 45867)

742
743
744
745
746
747
748
749

750
751
752
753
754
755
756

742
743
744
745
746
747
748

749
750
751
752
753
754
755
756

-
+

  blob_init(&sql, 0, 0);
  blob_appendf(&sql,
    "INSERT INTO x(label,url,score,date,snip) "
    " SELECT ftsdocs.label,"
    "        ftsdocs.url,"
    "        rank(matchinfo(ftsidx,'pcsx')),"
    "        datetime(ftsdocs.mtime),"
    "        snippet(ftsidx,'<mark>','</mark>',' ... ')"
    "        snippet(ftsidx,'<mark>','</mark>',' ... ',-1,35)"
    "   FROM ftsidx CROSS JOIN ftsdocs"
    "  WHERE ftsidx MATCH %Q"
    "    AND ftsdocs.rowid=ftsidx.docid",
    zPattern
  );
  if( srchFlags!=SRCH_ALL ){
    const char *zSep = " AND (";