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
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
