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
-
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()
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
On Tue, Aug 30, 2011 at 10:01 AM, sqlite-users-boun...@sqlite.org 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
To:
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 attached message matched the sqlite-users mailing