On Tue, Jan 9, 2018 at 12:30 PM, J Decker <d3c...@gmail.com> wrote: > swarmvtab3 test is still failing... (windows 10, msvc 2017) 10.0.16299.0 > > swarmvtab3-1.2.3... > Error: inconsistent ::dbcache and disk > swarmvtab3-1.3.3... > Error: inconsistent ::dbcache and disk > > This works
> > On Tue, Jan 9, 2018 at 11:46 AM, Simon Slavin <slav...@bigfraud.org> > wrote: > >> On 9 Jan 2018, at 6:46pm, Richard Hipp <d...@sqlite.org> wrote: >> >> > The latest change summary can be seen at >> > https://www.sqlite.org/draft/releaselog/3_22_0.html and the draft >> >> In <https://www.sqlite.org/draft/cli.html#expert> … >> >> For "clobbering" use "overwriting", if only for the sake of international >> readers. >> >> "If this option is pass a non-zero argument" should probably be "passed". >> >> I think you can come up with a more appropriate name than "expert". How >> about "cleverindex" or "indexwizard" or something. >> >> If this is easy to do, then for the .expert command and, by extension, >> the external function … >> >> Please allow an option "—ignoreexisting" for the .expert command. This >> option makes SQLite ignore any existing indexes except for the ones which >> implement primary keys. >> >> For extra points, with this option selected, in the output section, it >> includes DROP INDEX commands for the indexes it ignored before the CREATE >> INDEX command it prefers. >> >> For an additional bonus point, with this option selected, the command >> should recognise when the new index it recommended is the same as one of >> the existing indexes it ignored, and do the "no new indexes" thing. >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
