From: imeevma@tarantool.org To: korablev@tarantool.org Cc: tarantool-patches@freelists.org Subject: [tarantool-patches] [PATCH v1 1/1] sql: increase row_count when adding CHECK constraint Date: Fri, 19 Jul 2019 11:38:35 +0300 [thread overview] Message-ID: <5dba4410ecdc97004cd4a9890e302baa20b07529.1563525363.git.imeevma@gmail.com> (raw) If a CHECK constraint was added using an ALTER TABLE statement, row_count should be increased. Note that row_count does not increase if a CHECK constraint is added during the execution of a CREATE TABLE statement. For example: box.execute('CREATE TABLE t1(id INTEGER PRIMARY KEY);') box.execute('ALTER TABLE t1 ADD CONSTRAINT ck1 CHECK(id > 0);') Should return: - row_count: 1 However it was '0' before the patch. Closes #4363 --- https://github.com/tarantool/tarantool/issues/4363 https://github.com/tarantool/tarantool/tree/imeevma/gh-4363-increase-row_count-on-alter-table src/box/sql/build.c | 8 ++++++++ test/sql/row-count.result | 16 ++++++++++++++++ test/sql/row-count.test.lua | 7 +++++++ 3 files changed, 31 insertions(+) diff --git a/src/box/sql/build.c b/src/box/sql/build.c index 2aefa2a..183f875 100644 --- a/src/box/sql/build.c +++ b/src/box/sql/build.c @@ -1124,6 +1124,14 @@ vdbe_emit_ck_constraint_create(struct Parse *parser, return; sqlVdbeAddOp3(v, OP_SInsert, BOX_CK_CONSTRAINT_ID, 0, ck_constraint_reg + 5); + /* + * In case constraint was added using ALTER TABLE + * statement we should increase row_count. + */ + if (parser->create_table_def.new_space == NULL) { + sqlVdbeCountChanges(v); + sqlVdbeChangeP5(v, OPFLAG_NCHANGE); + } save_record(parser, BOX_CK_CONSTRAINT_ID, ck_constraint_reg, 2, v->nOp - 1, true); VdbeComment((v, "Create CK constraint %s", ck_def->name)); diff --git a/test/sql/row-count.result b/test/sql/row-count.result index e7841ca..fcea2cf 100644 --- a/test/sql/row-count.result +++ b/test/sql/row-count.result @@ -335,3 +335,19 @@ box.execute("DROP TABLE t1;") --- - row_count: 1 ... +-- +-- gh-4363: make sure that row_count has increased in the case of +-- ALTER TABLE <table> ADD CONSTRAINT <constraint> CHECK(<expr>); +-- +box.execute('CREATE TABLE t1(id INTEGER PRIMARY KEY);') +--- +- row_count: 1 +... +box.execute('ALTER TABLE t1 ADD CONSTRAINT ck1 CHECK(id > 0);') +--- +- row_count: 1 +... +box.execute('DROP TABLE t1;') +--- +- row_count: 1 +... diff --git a/test/sql/row-count.test.lua b/test/sql/row-count.test.lua index 9f5215c..7b43db7 100644 --- a/test/sql/row-count.test.lua +++ b/test/sql/row-count.test.lua @@ -73,3 +73,10 @@ box.execute("DROP TABLE t2;") box.execute("DROP TABLE t3;") box.execute("DROP TABLE t1;") +-- +-- gh-4363: make sure that row_count has increased in the case of +-- ALTER TABLE <table> ADD CONSTRAINT <constraint> CHECK(<expr>); +-- +box.execute('CREATE TABLE t1(id INTEGER PRIMARY KEY);') +box.execute('ALTER TABLE t1 ADD CONSTRAINT ck1 CHECK(id > 0);') +box.execute('DROP TABLE t1;') -- 2.7.4
next reply other threads:[~2019-07-19 8:38 UTC|newest] Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top 2019-07-19 8:38 imeevma [this message] 2019-07-22 11:22 ` [tarantool-patches] " n.pettik 2019-07-24 14:10 ` 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=5dba4410ecdc97004cd4a9890e302baa20b07529.1563525363.git.imeevma@gmail.com \ --to=imeevma@tarantool.org \ --cc=korablev@tarantool.org \ --cc=tarantool-patches@freelists.org \ --subject='Re: [tarantool-patches] [PATCH v1 1/1] sql: increase row_count when adding CHECK constraint' \ /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