On Fri, Jun 28, 2013 at 8:45 AM, Wolfgang Enzinger <[email protected]>wrote:
> Richard Hipp <drh@...> writes: > > > Nevertheless, it is important that you test the NGQP in your application. > > Getting back at the issue described in > http://article.gmane.org/gmane.comp.db.sqlite.general/81564 > > (which is *not* critical because an ANALYZE solves it, but nevertheless > might be interesting): > > This particular query ran fine (~3 secs.) up to version 3.7.14.1; from > version 3.7.15 on, it seems to never return. > > Seems a similar problem like described today by Elan Feingold, however in > my > case unfortunately the issue is still present in version 3.8 with the NGQP. > > The data contained in the concerned database are a bit sensitive; given you > are interested in this matter, would it be enough if I sent you the schema > (database with actual data deleted), the query and the content of > sqlite_stat1? > The combination of schema, sqlite_stat1, and query is normally sufficient, yes. Can you change (and shorten) the table and index and column names to obscure their meaning and origin, and give us written permission to include your case in the published test suite for SQLite? That would be even better. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
