Hi, I am using SQLite 3.5.6 with FTS2 extenstion. We have made some modifications to FTS module such that '=' operator is internally executed as match operator.
Inside xBestIndex function, if the expression is an '=' operator then setting some internal flags such that xFilter() understands them and executes the expression as a match operator. This is working fine when there is a single expression e.g select * from tab where col='text'. If there are multiple expressions in the where clause separated with OR operator this is not working as expected e.g select * from tab where col1='text1' OR col2=text2'. I found that bestVirtualIndex() is skipping OR expression and its subexpressions and not passing them to xBestIndex. I am not sure why SQLite bypasses xBestIndex for the expressions associated with OR operator. I need suggessions on how to make this work for all the expressions with = operator. Thanks in advance. Regards, Ishwar. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
