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
