From: "n.pettik" <korablev@tarantool.org>
To: tarantool-patches@freelists.org
Cc: Kirill Shcherbatov <kshcherbatov@tarantool.org>
Subject: [tarantool-patches] Re: [PATCH v3 2/3] box: run check constraint tests on space alter
Date: Tue, 14 May 2019 19:49:21 +0300 [thread overview]
Message-ID: <4F977C8F-67D9-4EE9-B3EC-14FCAFA3029B@tarantool.org> (raw)
In-Reply-To: <4f44a278-a591-4fbf-b2fa-8cb50200d4b0@tarantool.org>
> On 7 May 2019, at 12:53, Kirill Shcherbatov <kshcherbatov@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”.
next prev parent reply other threads:[~2019-05-14 16:49 UTC|newest]
Thread overview: 24+ messages / expand[flat|nested] mbox.gz Atom feed top
2019-04-16 13:51 [tarantool-patches] [PATCH v3 0/3] box: run checks on insertions in LUA spaces Kirill Shcherbatov
2019-04-16 13:51 ` [tarantool-patches] [PATCH v3 1/3] schema: add new system space for CHECK constraints Kirill Shcherbatov
2019-04-25 20:38 ` [tarantool-patches] " n.pettik
2019-05-07 9:53 ` Kirill Shcherbatov
2019-05-12 13:45 ` n.pettik
2019-05-12 15:52 ` Kirill Shcherbatov
2019-05-12 23:04 ` n.pettik
2019-05-13 7:11 ` Kirill Shcherbatov
2019-05-13 12:29 ` n.pettik
2019-05-13 13:13 ` Vladislav Shpilevoy
2019-04-16 13:51 ` [tarantool-patches] [PATCH v3 2/3] box: run check constraint tests on space alter Kirill Shcherbatov
2019-04-25 20:38 ` [tarantool-patches] " n.pettik
2019-05-07 9:53 ` Kirill Shcherbatov
2019-05-07 16:39 ` Konstantin Osipov
2019-05-07 17:47 ` [tarantool-patches] " Kirill Shcherbatov
2019-05-07 20:28 ` Konstantin Osipov
2019-05-11 12:15 ` n.pettik
2019-05-12 21:12 ` Konstantin Osipov
2019-05-13 7:09 ` Kirill Shcherbatov
2019-05-13 7:49 ` Konstantin Osipov
2019-05-14 16:49 ` n.pettik [this message]
2019-04-16 13:51 ` [tarantool-patches] [PATCH v3 3/3] box: user-friendly interface to manage ck constraints Kirill Shcherbatov
2019-04-25 20:38 ` [tarantool-patches] " n.pettik
2019-05-07 9:53 ` Kirill Shcherbatov
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=4F977C8F-67D9-4EE9-B3EC-14FCAFA3029B@tarantool.org \
--to=korablev@tarantool.org \
--cc=kshcherbatov@tarantool.org \
--cc=tarantool-patches@freelists.org \
--subject='[tarantool-patches] Re: [PATCH v3 2/3] box: run check constraint tests on space alter' \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox