Figured it out: match terms should be "l0l* h4x*" NOT "*l0l* *h4x*",
though it did work as expected with the older version. I'd suggest
keeping the old behaviour unless there is a performance-based reason not to.
On 2014-10-07, 2:49 PM, Sohail Somani wrote:
SELECT COUNT(*) FROM t_fts WHERE t_fts MATCH '*l0l* *h4x*';
COMMIT;
BEGIN TRANSACTION;
INSERT INTO t(key,value0,value1) VALUES('$key','l0l','h4x');
COMMIT;
SELECT '--- 2 ---';
SELECT COUNT(*) FROM t_fts WHERE t_fts MATCH '*l0l* *h4x*';
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
