Ed Willis wrote: > We were on a version which did not have the compile option > SQLITE_FTS3_MAX_EXPR_DEPTH and are moving up to one that does. As it > turns out we have run into a problem with one of our clients where > they hit this limit now where previously the query just worked.
Have a look at <http://www.sqlite.org/cgi/src/info/24fc9d4438a5615dd20af5419456166df83a72ea>. The limit existed previously, but was hardcoded. The introduction of the option did _not_ change the default value of this limit. > My question is whether or not theres any guidance on how to set this > limit at compile time? When you have more than 2^12 search terms, you need to increase it. (Is that your problem?) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users