Re: [sqlite] "unable to use function highlight in the requested context" in group by

Thank you, that works! I still think highlight() not working in this case may be a bug, though, since it only operates on a single row and in theory shouldn't be affected by the group by (but there may be limitations not obvious to me). Thanks again, Adrian ___

[sqlite] "unable to use function highlight in the requested context" in group by

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, '>', '<'