[Tarantool-patches] [PATCH v4 2/6] sql: refactor create_table_def and parse

Roman Khabibov roman.habibov at tarantool.org
Fri Sep 18 16:21:47 MSK 2020


Hi, Vlad and Nikita!

> On Sep 18, 2020, at 15:31, Nikita Pettik <korablev at tarantool.org> wrote:
> 
> On 17 Sep 16:43, Vladislav Shpilevoy wrote:
>> On 16.09.2020 15:27, Nikita Pettik wrote:
>>> On 12 Sep 00:51, Roman Khabibov wrote:
>>>> Move ck, fk constraint lists and autoincrement info from
>>>> struct create_table_def to struct Parse to make the code more
>>>> reusable when implementing <ALTER TABLE ADD COLUMN>.
>>>> 
>>>> Needed for #3075
>>>> ---
>>> 
>>> Does ANSI allow to include constraints in ADD COLUMN statement?
>> 
>> Yes.
>> 
>>> Why did you decide to add autoincrement to this list? Was there any
>>> discussion on this subj?
>> 
>> There is nothing to discuss. It is either a part of the standard or
>> not. Romain said it is (I didn't check though).
> 
> Unfortunatelly, this is false statement - autoincrement is not a part of
> standard (I've checked 2011 edition).

No no, Vlad. Maybe it was misunderstanding, I didn’t say that autoinc
is a part of the Standard. My point was the following:

The standard says that the column descriptions in <CREATE> and <ALTER>
are exactly the same. All consrtaints, <DEFAULT> and <COLLATE> are allowed.
But <AUTOINCREMENT> is not described in the standard. I suggested (Vlad
didn't mind) to continue this logic and support <AUTOINCREMENT> inside
<ALTER>, because there are no significant restrictions on this. Why can’t
we add a sequence to an already existing table?


More information about the Tarantool-patches mailing list