Bug #105877 for Sphinx-Search: Query method to return the whole index content

Wed Jul 15 09:23:21 2015 sebastien.moretti [...] unil.ch - Ticket created

Subject:	Query method to return the whole index content
Date:	Wed, 15 Jul 2015 15:22:55 +0200
To:	bug-Sphinx-Search [...] rt.cpan.org
From:	Sébastien MORETTI <sebastien.moretti [...] unil.ch>

Hi I wonder if there is a query to retrieve the whole content of the index, i.e. all possible results. Thanks -- Sébastien Moretti

Wed Jul 15 21:37:06 2015 jon [...] jschutz.net - Correspondence added

Subject:	Re: [rt.cpan.org #105877] Query method to return the whole index content
Date:	Thu, 16 Jul 2015 11:06:48 +0930
To:	bug-Sphinx-Search [...] rt.cpan.org
From:	Jon Schutz <jon [...] jschutz.net>

Hi Sébastien, This is the forum for reporting bugs. Please use http://sphinxsearch.com/forum/ for general questions. Short answer to your question is that the Perl API does not support a full scan, but you can use DBI with SphinxQL and do a 'select * from ...' to achieve what you want. -- Jon Schutz On 07/15/2015 10:53 PM, Moretti Sébastien via RT wrote: Show quoted text

> Wed Jul 15 09:23:21 2015: Request 105877 was acted upon. > Transaction: Ticket created by sebastien.moretti@unil.ch > Queue: Sphinx-Search > Subject: Query method to return the whole index content > Broken in: (no value) > Severity: (no value) > Owner: Nobody > Requestors: sebastien.moretti@unil.ch > Status: new > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=105877 > > > > Hi > > I wonder if there is a query to retrieve the whole content of the index, > i.e. all possible results. > > Thanks > > -- > Sébastien Moretti > >

Wed Jul 15 21:37:07 2015 The RT System itself - Status changed from 'new' to 'open'

Thu Jul 16 05:18:00 2015 sebastien.moretti [...] unil.ch - Correspondence added

Subject:	Re: [rt.cpan.org #105877] Query method to return the whole index content
Date:	Thu, 16 Jul 2015 11:17:43 +0200
To:	bug-Sphinx-Search [...] rt.cpan.org
From:	Sebastien Moretti <sebastien.moretti [...] unil.ch>

Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=105877 > > > Hi Sébastien, > > This is the forum for reporting bugs. Please use > http://sphinxsearch.com/forum/ for general questions. > > Short answer to your question is that the Perl API does not support a > full scan, but you can use DBI with SphinxQL and do a 'select * from > ...' to achieve what you want.

I will look for full scan. Thanks -- Sébastien Moretti

Thu Jul 16 07:10:54 2015 sebastien.moretti [...] unil.ch - Correspondence added

Subject:	[rt.cpan.org #105877] Query method to return the whole index content
Date:	Thu, 16 Jul 2015 13:10:39 +0200
To:	bug-Sphinx-Search [...] rt.cpan.org
From:	Sebastien Moretti <sebastien.moretti [...] unil.ch>

Hi according to SphinxSearch documentation, and to tests I did, it is possible with Sphinx::Search. Just use an empty string as query (with docinfo storage is set to extern) and the matching mode will switch automatically to SPH_MATCH_FULLSCAN and perform a full scan. See http://sphinxsearch.com/docs/current.html#matching-modes I did not have the right terminology to search for it. Thanks -- Sébastien Moretti