On Tue, Jan 9, 2018 at 12:30 PM, J Decker <[email protected]> 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 <[email protected]> > wrote: > >> On 9 Jan 2018, at 6:46pm, Richard Hipp <[email protected]> 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 >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
