Re: [sqlite] small sqlite fts snippet function or Fts Bug!

2015-01-27 Thread Dan Kennedy
On 01/27/2015 06:48 PM, boscowitch wrote: and the in an sqlite shell (SQLite version 3.8.8.1 2015-01-20 16:51:25) I get following for a select with snippet: EXAMPLE OUTPUT: sqlite select docid,*,snippet(test) from test where german match a; 1|[1] a b c|1] ba/b b c 2|[{[_.,:;[1] a b c|1] ba/b

Re: [sqlite] small sqlite fts snippet function or Fts Bug!

2015-01-27 Thread boscowitch
Yeah, -ID 4 was just a desperate experiment for a hack with longer data in the search to see if it would lead the snippet function to start grabbing the data from the start (or at least one word/char more). The offsets beeing wrong and therefore the b... was kinda expected of me, but in case it

[sqlite] small sqlite fts snippet function or Fts Bug!

2015-01-27 Thread boscowitch
Hello since it this bug report (+ a dirty-fix) it might be useful for both users and devs. that's why I send a copy to both mailing lists! I hope I don't bother the diligent devs who read all of both list, sry to them, and thx for sqlite btw. ;)! recently I wanted to use the snippet function in