Because of my (obviously wrong) automatic query generator I came across this 
issue:

CREATE  VIRTUAL TABLE myData USING FTS3 (content, body);

SELECT * FROM myData WHERE (content MATCH 'one') AND (body MATCH 'two');


What is the reason that the above query is not allowed and that

SELECT * FROM myData WHERE myData MATCH 'content: one body: two';

has to be used? Performance issues do not matter in this case.

Regards,
Hardy
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to