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

2019-07-15 Thread Jake Thaw
Dan Kennedy explained why this limitation exists: >On 27/2/62 05:47, Jake Thaw wrote: >>This may not strictly be a bug, but currently (3.27.2) a vtab cannot overload >>scalar functions in aggregate queries. >> >>Adding a check for TK_AGG_COLUMN in sqlite3VtabOverloadFunction makes my use >>case

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

2019-07-13 Thread Damian Adrian
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 ___

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

2019-07-10 Thread Clemens Ladisch
Damian Adrian wrote: > While using the FTS5 highlight() function in a group by query like this one: > > 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".

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

2019-07-10 Thread Damian Adrian
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, '>', '<'