On Fri, Jun 28, 2013 at 8:45 AM, Wolfgang Enzinger <sql...@enzinger.net>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
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to