mORMot Open Source

Amir

Member

From: UAE

Registered: 2010-08-17

Posts: 36

Problem with Token-Prefix MATCH Queries in a FTS4 SQLite Table

Hi,
When I post this query

"SELECT ROWID FROM UserData WHERE UserData MATCH 'UserID:2298691215 OR EMail:edc@edc.org';"

using ExecuteList(), the resulting TSQLTableJSON does not contain all matching records; but when I execute it (exactly the same statements) using the SQLite-Database-Editor ("SQLite Expert" in my case) everything is OK and always all records are retrieved as expected; This seems like an issue !!?.

I'm using the latest 1.18 version of mORMot.

Thanks.

---

Amir

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,206

Website

Re: Problem with Token-Prefix MATCH Queries in a FTS4 SQLite Table

Is INCLUDE_FTS3 conditional defined?

Do the queries work in SynDBExplorer?

Do simple queries like "SELECT ROWID FROM UserData WHERE UserData MATCH 'UserID:2298691215'" work as expected?

(EDIT)
I've enabled enhanced query syntax for SQLite3 FTS3/FTS4 MATCH operator.
The SQLITE_ENABLE_FTS3_PARENTHESIS conditional was not enabled in c.bat at compile time.
See http://synopse.info/fossil/info/7e787b3e3d

Please download the latest .obj from http://synopse.info/files/sqlite3obj.7z

Amir

Member

From: UAE

Registered: 2010-08-17

Posts: 36

Re: Problem with Token-Prefix MATCH Queries in a FTS4 SQLite Table

Thanks now the query works as expected.

---

Amir