Quoth Gert Van Assche <ger...@gmail.com>, on 2011-04-13 22:35:49 +0200: > SELECT snippet(example, '[', ']') FROM example WHERE CONTEXT MATCH > (SELECT TOKEN FROM example);
You're asking to match a single independently arbitrarily chosen token from anywhere in the table (which is not even the same as "matching at least one token from the table"), not whether it matches the one from the same row. Can you do WHERE CONTEXT MATCH TOKEN instead? I think you still need a full table scan for that, but it should return the right results unless FTS4 has some relevant restriction on the RHS of a MATCH. ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
