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 worked I would have manually substracted the offset
and put the markers in myself... so it wasn't part of the bug report
just a test how it behaves in that case.
Good to know for the future that its already fixed, thx for taking care
of it so fast!
boscowitch
Am Mittwoch, den 28.01.2015, 02:04 +0700 schrieb 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] <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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
