System.Data.Sqlite和FTS4 [英] System.Data.Sqlite and FTS4

问题描述

为什么当我用全文搜索语法编写查询时:

Why when i write a query with fulltext Search syntax like:

SELECT * FROM TABLENAME WHERE TABLENAME MATCH 'ColumnA:word1 OR ColumnB:word2'

查询结果总是返回0行?

The query result always return 0 rows?

我正在使用VBnet和

I'm using VBnet and the latest Ado.net provider from sqlite.org

问题是，当我尝试使用外部工具查询时，它运行良好(使用sqlite 3.7.9).

The problem is when i try the query with and external tool, it works well (with sqlite 3.7.9).

有任何线索吗? 预先感谢

Any clues? Thanks in advance

推荐答案

尽管System.Data.Sqlite是使用SQLITE_ENABLE_FTS3编译的，并且支持FTS，但没有使用SQLITE_ENABLE_FTS3_PARENTHESIS编译的，因此启用了

Although System.Data.Sqlite is compiled using SQLITE_ENABLE_FTS3 and supports FTS, it doesn't compiled with SQLITE_ENABLE_FTS3_PARENTHESIS which enables Enhanced Query Syntax. And you are using Enhanced Query Syntax in your query, thus it didn't works as you expect.

您需要修改查询或进行自定义构建(遵循定义了SQLITE_ENABLE_FTS3_PARENTHESIS的System.Data.Sqlite的构建过程.

You need to either modify you query, or do a custom build (follow build procedures) of System.Data.Sqlite with SQLITE_ENABLE_FTS3_PARENTHESIS defined.

这篇关于System.Data.Sqlite和FTS4的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！