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
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
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
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
### 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:
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
7 matches
Mail list logo
