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] <b>a</b> b c
2|[{[_.,:;[1] a b c|1] <b>a</b> b c
3|1[1] a b c|1[1] <b>a</b> b c
4|[1] a b c|1] a <b>b</b> c
5|[1] a b c|[1] <b>a</b> b c
-As you can see for id 1 and 2 <b> is at the right position
but all beginning non-alphanumerical [,{, etc. are just left out in the
snippet.
-ID 4 does not help and breaks the offsets so even worse....
Thanks for reporting this. The issue with (1) and (2) is now fixed here:
http://www.sqlite.org/src/info/adc9283dd9b
I think it is a bug in the input data causing the problem in (4). The
values inserted into "test" and "testdata" are just slightly different.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users