Dear sqlite-users. I am Nao Shoji and I work as a server side engineer. In this time, I contacted to yours, because I faced a sqlite problem.
On a daily basis, I develop web applications by PHP. Our application uses sqlite database as full-text searching engine. Additionally, a table format of sqlite database is fts3. As a main processing, a very long query is executed on the table. (Example: SELECT * FROM my_table WHERE 1 = 1 AND tempo >= 100 AND tempo <= 150 AND word MATCH 'AAAA OR BBBB OR CCCC OR ... ' LIMIT 0, 100) It is no problem in case of older PHP versions. But in case of new PHP versions, PDOException often occurs. That exception is shown as follows. exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 FTS expression tree is too large (maximum depth 12) This exception depends PHP version. I confirmed an operation of application which is used fts3 table on some PHP versions. That results are shown as follows, - PHP 5.3.20(linux) : The problem doesn't occur. - PHP 5.3.28(linux) : The problem occurs. - PHP 5.4.7(xampp of windows) : The problem doesn't occur. - PHP 5.5(xampp of windows) : The problem occurs. Please tell me the solution of problem. If possible, I would like to receive to your response by this e-mail address([email protected]). (I don't join sqlite-users yet.) Regards, sqlite-users. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
