On Tue, 6 Oct 2015 17:39:20 +0000
Hick Gunter <hick at scigames.at> wrote:
> AFAICT the FROM clause is superflous, as the function has no
> (supported) way of detecting which table(s) the FROM clause contains.
> What is your "reindex_virtual_table()" function (I assume it is a
> user implemented function) supposed to do?
I wrote it thinking it's selfexplaining, but now I think I wrote it too fast.
reindex_virtual_table() is a function defined inside Virtual Table code that
forces an internal reindex of its data.
In FTS3/4, for example, you can do an "INSERT INTO
fts_virtual_table(fts_virtual_table) VALUES('rebuild');" to reindex the FTS
virtual table.
And I say I wrote it too fast because a virtual table don't need to have an
internal index, depends on what is it for and its implementation.
> -----Urspr?ngliche Nachricht-----
> Von: Eduardo Morras [mailto:emorrasg at yahoo.es]
> Gesendet: Dienstag, 06. Oktober 2015 19:08
> An: sqlite-users at mailinglists.sqlite.org
> Betreff: Re: [sqlite] Multiple connections to in-memory DB and
> virtual tables
>
> On Tue, 6 Oct 2015 15:39:08 +0100
> Simon Slavin <slavins at bigfraud.org> wrote:
>
> > There are also things Virtual Tables can't do. For instance you
> > cannot index a Virtual Table using SQL commands.
>
> Does "SELECT reindex_virtual_table() FROM virtual_table" count as SQL
> command only?
>
>
> --- ---
> Eduardo Morras <emorrasg at yahoo.es>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___________________________________________
> Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> FN 157284 a, HG Wien
> Klitschgasse 2-4, A-1130 Vienna, Austria
> Tel: +43 1 80100 0
> E-Mail: hick at scigames.at
>
> This communication (including any attachments) is intended for the
> use of the intended recipient(s) only and may contain information
> that is confidential, privileged or legally protected. Any
> unauthorized use or dissemination of this communication is strictly
> prohibited. If you have received this communication in error, please
> immediately notify the sender by return e-mail message and delete all
> copies of the original communication. Thank you for your cooperation.
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras <emorrasg at yahoo.es>
