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

Vladislav Shpilevoy v.shpilevoy at tarantool.org
Sat Oct 3 01:08:43 MSK 2020


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.


More information about the Tarantool-patches mailing list