Hi,
I saw in the timeline that Sqlite developers are working on FTS4.
Great news! :-)
I would like to suggest a couple of fixes.
The following syntax involving two or more words and double quotes
returns an error:
...MATCH 'Electric car -"general motors"'
...MATCH 'Electric car title:"gene
Hi,
Thanks Dan, Richard and Max for the (ultra) fast answer and Dan and
Richard for the fix, because, as Max says, the bug is fixed now in
3.7.3.
But I have a problem compiling sqlite with VC++. I was able to compile
3.7.2 without issues.
With 3.7.3 The linker says:
'error LNK2001: unresolved e
Max,
Thank you for your fast answer.
I already knew the thread you suggest.
The issue here is that the same join works fine on 3.7.2 with a normal table:
SELECT news1.number, news2.title
FROM (SELECT number FROM news LIMIT 50) as news1, news2
WHERE news1.number=news2.docid
When you join with a
Hi,
Given this simple query with a subquery in FROM and a join with a FTS3 table:
SELECT news1.number, fts_news.title
FROM (SELECT number FROM news LIMIT 50) as news1, fts_news
WHERE news1.number=fts_news.docid
The query runs in 15ms in 3.6.23. The same query runs in *8 seconds* in 3.7.2.
If I
Dan,
Thanks for the (ultra)fast fix! :-)
-
[9e075e70f0] Leaf Increase the estimated cost of using a virtual table as
the outer loop of a join when there exists an ORDER BY clause that is not
satisfied by the virtual table. Fix for 775b39dd3c. (user: dan, tags: trunk)
09:11 Ticket 775b39d
### BUG: Sqlite 3.6.23. Optimizer does not use indexes when a table is
joined with a fts3 table
Given those two tables:
Table a
. number: integer primary key
. date: double (julian)
. index: dateindx (index of column date)
Total rows: 37866
Table fts (fts3 table)
. title: string
Total rows: 3786
Thanks Marbex, Puneed and specially to Scott for the snippet() tip.
'ined' is Porter stemmed to 'in'! :-)
So that is why it finds so many rows.
Now, to find 17081 rows from a table with 25672, fts3 took 4.47 seconds!
The query is:
select title from fts_news where description match 'in'
If
d %'
The query returns 0 rows.
I'm using SqliteSpy with sqlite 3.6.17
Jochi Martínez
www.bfreenews.com
On Sat, Sep 26, 2009 at 6:36 PM, marbex wrote:
>
>
> Shopsland gmail wrote:
>>
>> ? ?select title from fts_news where fts_news match 'ined'
>>
&g
Hi,
Mining my fts3 table stemmed with Porter I found that there is a 'phantom'
token indexed by fts3.
When I issue this query:
select title from fts_news where fts_news match 'ined'
I got about 700 rows that do not have the word 'ined' in any form (ie: ined
or inedible).
If I issue those que
9 matches
Mail list logo