Nao Shoji wrote: > SELECT * FROM my_table WHERE ... word MATCH 'AAAA OR BBBB OR CCCC OR ... ' > > FTS expression tree is too large (maximum depth 12)
This means that there are too many (more than 2^12) search words. You could split the word list so that you have multiple queries. (You might be able to use subqueries.) Alternatively, recompile SQLite with a larger value of SQLITE_FTS3_MAX_EXPR_DEPTH. (This probably requires recompiling PHP itself.) Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
