I have noticed that certain (complex) select queries return unexpected data
(missing rows) on my upgraded SQLite databases.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? Is it necessary to run the ANALYZE
command after upgrading (altering table columns etc) a database? Thanks!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
