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 function as expected. > >I think it has always been this way. > >The tricky case is when there is a GROUP BY with an expression list that the >virtual table cannot optimize as an ORDER BY. In that case the virtual table >cursor will be closed before the overloaded function is invoked, which breaks >the implementation of most overloaded functions (including the built-in ones). > >Dan.
-Jake On Sat, Jul 13, 2019 at 7:36 PM Damian Adrian <damian.adria...@gmail.com> wrote: > > 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-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users