From: Vladislav Shpilevoy <v.shpilevoy@tarantool.org>
To: Chris Sosnin <k.sosnin@tarantool.org>,
tarantool-patches@dev.tarantool.org,
Kirill Yukhin <kyukhin@tarantool.org>
Subject: Re: [Tarantool-patches] [PATCH] sql: fix assertion fail when selecting from _vfunc
Date: Sun, 22 Dec 2019 16:00:41 +0100 [thread overview]
Message-ID: <980af590-b69a-26ed-690f-d7ecadf3749e@tarantool.org> (raw)
In-Reply-To: <20191221185730.16148-1-k.sosnin@tarantool.org>
LGTM.
On 21/12/2019 19:57, Chris Sosnin wrote:
> 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;]])
>
next prev parent reply other threads:[~2019-12-22 15:00 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
2019-12-22 15:00 ` Vladislav Shpilevoy [this message]
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=980af590-b69a-26ed-690f-d7ecadf3749e@tarantool.org \
--to=v.shpilevoy@tarantool.org \
--cc=k.sosnin@tarantool.org \
--cc=kyukhin@tarantool.org \
--cc=tarantool-patches@dev.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