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 a child table that can return multiple results per parent, but only one parent is desired in the output, along with an arbitrary child snippet) Regards Rafael fbuser wrote: > >>> From: fbu...@web.de >>> To: sqlite-users@sqlite.org >>> Date: Tue, 30 Aug 2011 16:01:24 +0200 (CEST) >>> Subject: Bug in using overloaded functions for virtual tables? >>> >>> SELECT DISTINCT offsets(pages) FROM pages; >>> -or- >>> SELECT offsets(pages),count(*) FROM pages GROUP BY 1 >>> >>> => error message: unable to use function offsets in the requested >>> context >>> >>> Is this is a bug or a restriction, which is not documented? If this is a >>> restriction it should be considered as a feature request to allow using >>> virtual table functions in queries with the DISTINCT keyword or the >>> GROUP BY >>> clause. Otherwise the bug should be fixed :-) > -- View this message in context: http://old.nabble.com/Bug-in-using-overloaded-functions-for-virtual-tables--tp32364864p32674947.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
