Hello,
While using the FTS5 highlight() function in a group by query like this one:
CREATE VIRTUAL TABLE entries USING fts5(id UNINDEXED, content);
INSERT INTO entries
VALUES ('one', 'one'), ('two', 'another one' ), ('two', 'another two' );
SELECT
group_concat(highlight(entries, 1, '>', '<'))
FROM entries
WHERE entries MATCH 'an*'
GROUP BY id;
I get "Error: unable to use function highlight in the requested context".
I have tried various sub-query combinations with the same result; the
FTS4 snippet() function results in a similar error; I am using SQLite
3.22.0. Full list:
https://gist.github.com/lemon24/49b0a999b26f7a40ba23d8d4fab4a828
My actual use case is a bit more involved (I'm trying to build a
json_group_array with the highlighted snippets of a single group), but
in the end I get the same error.
Is this by design? Am I doing something wrong? Is there another way of
obtaining a similar result?
Thank you,
Adrian
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
