Dne 28.8.2014 16:48, Clemens Ladisch napsal(a):
Then try with 3.8.6.
Ooooouuu . .sorry again.
I have tested it with 3.8.6 and the query plan looks ok now.
SCAN TABLE nameftsTable VIRTUAL TABLE INDEX 18:
EXECUTE LIST SUBQUERY 1
But I also tested it with my version again and I'm getting the same (correct)
query plan now.
I cannot understand how it is possible :-).
The only thing I changed is that in the meantime I've recreated my ftsTable.
So it was either in some strange state I cannot reproduce now or I am simply
overworked :-).
Or maybe I accidentally used '=' or 'is' instead of 'match'.
However, many thanks for your support, now it all seems much more clear.
Milan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
