Re: [Tarantool-patches] [PATCH 4/5] sql: replace control pragmas by SET

[Vladislav Shpilevoy <v.shpilevoy@tarantool.org>]

On 27/11/2019 14:01, Mergen Imeev wrote:
> On Wed, Nov 27, 2019 at 03:49:42PM +0300, Konstantin Osipov wrote:
>> Ok, this goal is nice, but now that it is clear it is a different goal than
>> fixing pragmas, what about making e.g. box.cfg settings available from all
>> interfaces? Adding access to global defaults, not just session defaults? Or
>> plugin settings, like log? Even though the declared  aim is to come up with
>> a general solution, the implementation leaves a lot of questions unanswered.
>>
> So, at the end we have the following questions:
> 1) Should we return the SQL tuning value when SET is used as
> follows:
> 
> SET <setup name>;

Sounds ok. But even more ok - just keep PRAGMAs as they
are.

> 
> 2) Should we remove _vsession_settings from the problem.

I always vote yes, when a question is whether should we
delete some code, drop a system space, etc.

> 
> 3) If we move sysview out of the problem, where should we move it.

To /dev/null. Together with all the other SQL. But nobody
listens anyway. So we are going to push this space and support
it forever.