Re: [sqlite] Bug in using overloaded functions for virtual tables?

Here are the opcodes generated for each operation using the EXPLAIN command sqlite> explain select offsets(pasta_text), DataPasta from pasta_text where past a_text match 'andamento*'; addr opcode p1p2p3p4 p5 comment -

Re: [sqlite] Bug in using overloaded functions for virtual tables?

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()

Re: [sqlite] Bug in using overloaded functions for virtual tables?

I experience the same situation on the following query: select offsets(pasta_text), snippet(pasta_text), DataPasta from pasta_text WHERE pasta_text match 'andamento*' group by DataPasta order by DataPasta Which desired output would be all matches grouped by date (the full query is joined from

Re: [sqlite] Bug in using overloaded functions for virtual tables?

Von: "Richard Hipp" <d...@sqlite.org> Gesendet: 30.08.2011 16:30:28 An: sqlite-users@sqlite.org Betreff: [sqlite] Bug in using overloaded functions for virtual tables? >On Tue, Aug 30, 2011 at 10:01 AM, <sqlite-users-boun...@sqlite.org> wrote: > >> The attache

[sqlite] Bug in using overloaded functions for virtual tables?

On Tue, Aug 30, 2011 at 10:01 AM, wrote: > The attached message matched the sqlite-users mailing list's content > filtering rules and was prevented from being forwarded on to the list > membership. > -- Forwarded message -- > From: fbu...@web.de >