Hi, The problem is that the database is around 100 MB large (the error goes
away if I remove unimportant data). Also, it contains data I'd like to keep
private. I do have a specific select query that produces what I believe is a
data error (tested in the latest SQLite version). Can I zip the database and
send it to the sqlite team for analysis? > From: slav...@bigfraud.org
> Date: Thu, 18 Aug 2011 13:57:31 +0100
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANALYZE necessary after database upgrade?
>
>
> On 18 Aug 2011, at 1:50pm, Kristoffer Danielsson wrote:
>
> > I have noticed that certain (complex) select queries return unexpected data
> > (missing rows) on my upgraded SQLite databases.
>
> What do you mean by 'upgraded' ?
>
> > My guess is that the optimizer makes an erroneous decision on some index
> > (I'm using both sqlite_stat1 and sqlite_stat2). Is this a reasonable guess?
>
> Depends what you mean by 'missing rows'. If you think SQLite is giving you
> /wrong/ information, please describe it in more detail, showing both the
> output of the query you think is wrong, and some other output from the
> database showing why you think it's wrong.
>
> > Is it necessary to run the ANALYZE command after upgrading (altering table
> > columns etc) a database? Thanks!
>
> ANALYZE just helps SQLite decide what the fastest way to do something is. It
> should never change which rows are changed or returned. So it will
> definitely not fix a data problem.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
