[tarantool-patches] Re: [PATCH v3 2/3] box: run check constraint tests on space alter

n.pettik korablev at tarantool.org
Tue May 14 19:49:21 MSK 2019



> On 7 May 2019, at 12:53, Kirill Shcherbatov <kshcherbatov at tarantool.org> wrote:
> 
> 
>> One unpleasant “feature” that I’ve noticed:
>> 
>> create table t4 (id int primary key check(id > id*id))
>> insert into t4 values(0.5)
>> - error: 'Failed to execute SQL statement: Check constraint failed ''CK_CONSTRAINT_1_T4'':
>>    id > id*id’
>> 
>> Conversion to INT occurs before tuples reaches on_replace trigger.
>> We should discuss what to do with that. I guess you already raised
>> this question when we were talking about typeof() functions inside
>> check constraint.
> We should live with it ;)

Please, document this “feature”.





More information about the Tarantool-patches mailing list