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

Reply via email to