From: Chris Sosnin <k.sosnin@tarantool.org> To: v.shpilevoy@tarantool.org, tarantool-patches@dev.tarantool.org Subject: [Tarantool-patches] [PATCH] sql: fix assertion fail when selecting from _vfunc Date: Sat, 21 Dec 2019 21:57:30 +0300 [thread overview] Message-ID: <20191221185730.16148-1-k.sosnin@tarantool.org> (raw) In-Reply-To: <cc88c612-477f-cc13-05ce-b97e7c93887a@tarantool.org> Hi! Thank you for the review and for your fixes! I agree with your changes, although I had to fix the test because it does not fail even without this fix. New query will cause assertion with an old format. The patch below: The assertion mentioned #4666 fails because it was forgotten to update _vfunc format along with _func in 2.2.1. This leads to bad allocation of vdbe cursor and setting wrong memory to 0. Closes #4666 --- branch: https://github.com/tarantool/tarantool/tree/ksosnin/gh-4666-select-from-vfunc issue: https://github.com/tarantool/tarantool/issues/4666 src/box/bootstrap.snap | Bin 5921 -> 5916 bytes src/box/lua/upgrade.lua | 7 +++++++ test/box-py/bootstrap.result | 9 ++++++++- test/sql/engine.cfg | 1 + test/sql/gh-4666-sql-select-from-vfunc.result | 11 +++++++++++ .../gh-4666-sql-select-from-vfunc.test.lua | 4 ++++ 6 files changed, 31 insertions(+), 1 deletion(-) create mode 100644 test/sql/gh-4666-sql-select-from-vfunc.result create mode 100644 test/sql/gh-4666-sql-select-from-vfunc.test.lua diff --git a/src/box/lua/upgrade.lua b/src/box/lua/upgrade.lua index 07f1e0317..e57c23547 100644 --- a/src/box/lua/upgrade.lua +++ b/src/box/lua/upgrade.lua @@ -951,8 +951,15 @@ local function drop_func_collation() _func.index.name:alter({parts = {{'name', 'string'}}}) end +local function update_vfunc_format() + local _func = box.space[box.schema.FUNC_ID] + local _vfunc = box.space[box.schema.VFUNC_ID] + _vfunc:format(_func:format()) +end + local function upgrade_to_2_3_1() drop_func_collation() + update_vfunc_format() end -------------------------------------------------------------------------------- diff --git a/test/box-py/bootstrap.result b/test/box-py/bootstrap.result index 938a7631e..56bb43872 100644 --- a/test/box-py/bootstrap.result +++ b/test/box-py/bootstrap.result @@ -63,7 +63,14 @@ box.space._space:select{} 'type': 'string'}, {'name': 'last_altered', 'type': 'string'}]] - [297, 1, '_vfunc', 'sysview', 0, {}, [{'name': 'id', 'type': 'unsigned'}, {'name': 'owner', 'type': 'unsigned'}, {'name': 'name', 'type': 'string'}, {'name': 'setuid', - 'type': 'unsigned'}]] + 'type': 'unsigned'}, {'name': 'language', 'type': 'string'}, {'name': 'body', + 'type': 'string'}, {'name': 'routine_type', 'type': 'string'}, {'name': 'param_list', + 'type': 'array'}, {'name': 'returns', 'type': 'string'}, {'name': 'aggregate', + 'type': 'string'}, {'name': 'sql_data_access', 'type': 'string'}, {'name': 'is_deterministic', + 'type': 'boolean'}, {'name': 'is_sandboxed', 'type': 'boolean'}, {'name': 'is_null_call', + 'type': 'boolean'}, {'name': 'exports', 'type': 'array'}, {'name': 'opts', + 'type': 'map'}, {'name': 'comment', 'type': 'string'}, {'name': 'created', + 'type': 'string'}, {'name': 'last_altered', 'type': 'string'}]] - [304, 1, '_user', 'memtx', 0, {}, [{'name': 'id', 'type': 'unsigned'}, {'name': 'owner', 'type': 'unsigned'}, {'name': 'name', 'type': 'string'}, {'name': 'type', 'type': 'string'}, {'name': 'auth', 'type': 'map'}]] diff --git a/test/sql/engine.cfg b/test/sql/engine.cfg index 284c42082..5e8199ad8 100644 --- a/test/sql/engine.cfg +++ b/test/sql/engine.cfg @@ -5,6 +5,7 @@ "sql-debug.test.lua": { "memtx": {"engine": "memtx"} }, + "gh-4666-sql-select-from-vfunc.test.lua": { }, "bind.test.lua": { "remote": {"remote": "true"}, "local": {"remote": "false"} diff --git a/test/sql/gh-4666-sql-select-from-vfunc.result b/test/sql/gh-4666-sql-select-from-vfunc.result new file mode 100644 index 000000000..d57c66867 --- /dev/null +++ b/test/sql/gh-4666-sql-select-from-vfunc.result @@ -0,0 +1,11 @@ +-- +-- Make sure assertion does not fail. +-- +box.execute([[select "id" from "_vfunc" where "id" = 1;]]) +--- +- metadata: + - name: id + type: unsigned + rows: + - [1] +... diff --git a/test/sql/gh-4666-sql-select-from-vfunc.test.lua b/test/sql/gh-4666-sql-select-from-vfunc.test.lua new file mode 100644 index 000000000..fa296e1e1 --- /dev/null +++ b/test/sql/gh-4666-sql-select-from-vfunc.test.lua @@ -0,0 +1,4 @@ +-- +-- Make sure assertion does not fail. +-- +box.execute([[select "id" from "_vfunc" where "id" = 1;]]) -- 2.21.0 (Apple Git-122.2)
next prev parent reply other threads:[~2019-12-21 18:57 UTC|newest] Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top 2019-12-17 10:26 Chris Sosnin 2019-12-20 21:10 ` Vladislav Shpilevoy 2019-12-21 18:57 ` Chris Sosnin [this message] 2019-12-22 15:00 ` Vladislav Shpilevoy 2020-01-10 7:40 Chris Sosnin 2020-01-15 17:29 ` Nikita Pettik 2020-01-16 8:10 ` Chris Sosnin
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=20191221185730.16148-1-k.sosnin@tarantool.org \ --to=k.sosnin@tarantool.org \ --cc=tarantool-patches@dev.tarantool.org \ --cc=v.shpilevoy@tarantool.org \ --subject='Re: [Tarantool-patches] [PATCH] sql: fix assertion fail when selecting from _vfunc' \ /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