[Tarantool-patches] [PATCH] sql: allow accessing list of collations via pragma

[Nikita Pettik]

On 10 Jan 10:52, Chris Sosnin wrote:
> 'pragma collation_list' uses _collation space, although user
> may have no access to it. Thus, we replace it with the
> corresponding view.
> 
> Closes #4713
> ---
> branch: https://github.com/tarantool/tarantool/tree/ksosnin/gh-4713-pragma-collation-list
> issue: https://github.com/tarantool/tarantool/issues/4713
> 
>  src/box/sql/pragma.c        |   2 +-
>  test/sql/collation.result   | 286 +++++++++++++++++++++++++++++++++++-
>  test/sql/collation.test.lua |   1 -
>  3 files changed, 284 insertions(+), 5 deletions(-)
> 
> diff --git a/src/box/sql/pragma.c b/src/box/sql/pragma.c
> index 28ba64500..636f519ef 100644
> --- a/src/box/sql/pragma.c
> +++ b/src/box/sql/pragma.c
> @@ -241,7 +241,7 @@ sql_pragma_collation_list(struct Parse *parse_context)
>  	char key_buf[16];
>  	char *key_end = mp_encode_array(key_buf, 0);
>  	box_tuple_t *tuple;
> -	box_iterator_t *it = box_index_iterator(BOX_COLLATION_ID, 0, ITER_ALL,
> +	box_iterator_t *it = box_index_iterator(BOX_VCOLLATION_ID, 0, ITER_ALL,
>  						key_buf, key_end);
>  	if (it == NULL) {
>  		parse_context->is_aborted = true;
> diff --git a/test/sql/collation.result b/test/sql/collation.result
> index 4e43a7cb7..924ac424c 100644
> --- a/test/sql/collation.result
> +++ b/test/sql/collation.result
> @@ -360,11 +360,291 @@ box.schema.user.create('tmp')
>  box.session.su('tmp')
>  ---
>  ...
> --- Error: read access to space is denied.
>  box.execute("pragma collation_list")
>  ---
> -- null
> -- Read access to space '_collation' is denied for user 'tmp'
> +- metadata:
> +  - name: seq
> +    type: integer
> +  - name: name
> +    type: text
> +  rows:
> 
> //snipped 276 rows

Please, never truncate output of format-patch. At least when you
send patch for the first review iteration.

Content returned by 'pragma collation_list' is already verified in
sql-tap/collation.test.lua. So I guess it is enough to check that
box.execute("pragma collation_list") does not throw an error.

> diff --git a/test/sql/collation.test.lua b/test/sql/collation.test.lua
> index 9a2042c09..cbe6e7799 100644
> --- a/test/sql/collation.test.lua
> +++ b/test/sql/collation.test.lua
> @@ -103,7 +103,6 @@ box.schema.user.revoke('guest', 'read,write,execute', 'universe')
>  -- gh-3857 "PRAGMA collation_list" invokes segmentation fault.
>  box.schema.user.create('tmp')
>  box.session.su('tmp')
> --- Error: read access to space is denied.
>  box.execute("pragma collation_list")
>  box.session.su('admin')
>  box.schema.user.drop('tmp')
> -- 
> 2.21.0 (Apple Git-122.2)
>