Stepping through execution for queries with and without GROUP BY clauses, I could see that, when preparing a query containing a Group By clause, the parser assigns a TK_AGG_COLUMN type to first argument of the offsets() and snippet() functions, thus breaking out of sqlite3VtabOverloadFunction() that is called from sqlite3ExprCodeTarget() with a TK_FUNCTION op code, finally not being able to look up the overloaded version of the functions, executing the default, sqlite3InvalidFunction implementation. Doing some tests and including the TK_AGG_COLUMN in the conditions that should continue the overload mechanism, the correct implementations are found and assigned, but execution crashes later on, when stepping the resultset - looks like we then have an invalid fulltext cursor. -- View this message in context: http://old.nabble.com/Bug-in-using-overloaded-functions-for-virtual-tables--tp32364864p32681827.html Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users