From: "n.pettik" <korablev@tarantool.org> To: "N. Tatunov" <hollow653@gmail.com> Cc: tarantool-patches@freelists.org Subject: [tarantool-patches] Re: [PATCH 2/2] sql: statistics removal after dropping an index Date: Thu, 5 Apr 2018 21:01:48 +0300 [thread overview] Message-ID: <926E041C-FCCB-46B0-B49B-21292CB70813@tarantool.org> (raw) In-Reply-To: <CAEi+_ar9jpqcJF25DyoajMDaYaH3S9_gEWXKO1dikpNz6NKw5Q@mail.gmail.com> Hello. See 2 minor remarks. The rest seems to be OK. I have noticed, that there are wrong indentations on your branch: @@ -2415,7 +2426,7 @@ sqlite3DropTable(Parse * pParse, SrcList * pName, int isView, int noErr) */ sqlite3BeginWriteOperation(pParse, 1); - sqlite3ClearStatTables(pParse, "tbl", pTab->zName); + sql_clear_stat_tables(pParse, pTab->zName, NULL); @@ -3417,7 +3428,7 @@ sqlite3DropIndex(Parse * pParse, SrcList * pName, Token * pName2, int ifExists) * But firstly, delete statistics since schema * changes after DDL. */ - sqlite3ClearStatTables(pParse, "idx", pIndex->zName); + sql_clear_stat_tables(pParse, pIndex->pTable->zName, pIndex->zName); Please, fix them. > On 4 Apr 2018, at 19:34, Hollow111 <hollow653@gmail.com> wrote: > > @@ -2210,16 +2210,17 @@ sqliteViewResetAll(sqlite3 * db) > * Remove entries from the _sql_statN tables (for N in (1, 4)) > * after a DROP INDEX or DROP TABLE command. > * > - * @param table_name table to be dropped or > - * the table that contains index to be dropped > - * @param idx_name index to be dropped > + * @param parse The parsing context. > + * @param table_name The table to be dropped or > + * the table that contains index to be dropped. > + * @param idx_name Index to be dropped. > */ > static void > -sql_clear_stat_tables(Parse *parse, > - const char *table_name, > - const char *idx_name) > +sql_clear_stat_tables(Parse *parse, const char *table_name, > + const char *idx_name > + ) This bracket should be on previous line. > { > - if(idx_name) { > + if(idx_name != NULL) { > sqlite3NestedParse(parse, > "DELETE FROM \"_sql_stat1\" WHERE (\"idx\"=%Q AND " > "\"tbl\"=%Q)", >
next prev parent reply other threads:[~2018-04-05 18:01 UTC|newest] Thread overview: 16+ messages / expand[flat|nested] mbox.gz Atom feed top 2018-04-03 21:37 [tarantool-patches] " N.Tatunov 2018-04-04 14:06 ` [tarantool-patches] " n.pettik 2018-04-04 15:46 ` Hollow111 2018-04-04 16:11 ` n.pettik 2018-04-04 16:34 ` Hollow111 2018-04-05 18:01 ` n.pettik [this message] [not found] ` <CAEi+_aq5oyeB0cbnxAXXjQqu=h+PCGaaZuLkk3p33yq371+Xog@mail.gmail.com> 2018-04-07 2:12 ` Hollow111 2018-04-09 12:16 ` n.pettik 2018-04-12 6:06 ` Hollow111 2018-04-13 8:50 ` n.pettik 2018-04-14 4:29 ` Hollow111 2018-04-14 8:13 ` n.pettik 2018-04-15 6:09 ` Hollow111 2018-04-15 6:35 ` Hollow111 2018-04-15 22:41 ` n.pettik 2018-04-16 13:19 ` Kirill Yukhin
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=926E041C-FCCB-46B0-B49B-21292CB70813@tarantool.org \ --to=korablev@tarantool.org \ --cc=hollow653@gmail.com \ --cc=tarantool-patches@freelists.org \ --subject='[tarantool-patches] Re: [PATCH 2/2] sql: statistics removal after dropping an index' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox