[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