[Tarantool-patches] [PATCH v4 6/6] sql: support column addition

[Roman Khabibov]

Hi!

> On Oct 3, 2020, at 01:08, Vladislav Shpilevoy <v.shpilevoy at tarantool.org> wrote:
> 
> Hi! Thanks for the fixes!
> 
>>>>> In Postgres for instance, one can add column for non-empty table and
>>>>> it is considered to be ok (new column is filled with default value).
>>>>> We can use ephemeral tables as temporary holder while rebuilding space.
>>>> 
>>>> Ephemeral spaces can't be used at least because of vinyl, because may
>>>> not fit into the memory.
>>> 
>>> Anyway they are used for vinyl even now.
>>> 
>>>> With Roman we decided to implement non-empty
>>>> alter later as a separate issue.
>>> 
>>> Ok, then please create follow-up issue with proposed approach.
>> We may patch the box code and implement DEFAULT (and NULL ?)inside
>> box. This trigger will update space’s tuples during <ALTER TABLE ADD COLUMN>.
>> In any case, we need to patch box. We will do it later.
> 
> I don't think Nikita meant that you need to implement it now. He
> said you need to ensure the task is not lost. So you either need
> to find an existing issue about this, or create a new issue.
https://github.com/tarantool/tarantool/issues/3206