From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D4BD2E459 for ; Tue, 14 May 2019 12:49:24 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JAIXUEr79tuZ for ; Tue, 14 May 2019 12:49:24 -0400 (EDT) Received: from smtpng1.m.smailru.net (smtpng1.m.smailru.net [94.100.181.251]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id B99B12909A for ; Tue, 14 May 2019 12:49:23 -0400 (EDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.8\)) Subject: [tarantool-patches] Re: [PATCH v3 2/3] box: run check constraint tests on space alter From: "n.pettik" In-Reply-To: <4f44a278-a591-4fbf-b2fa-8cb50200d4b0@tarantool.org> Date: Tue, 14 May 2019 19:49:21 +0300 Content-Transfer-Encoding: quoted-printable Message-Id: <4F977C8F-67D9-4EE9-B3EC-14FCAFA3029B@tarantool.org> References: <5ecf24bcc8c4676d1bcfe0a36c9bb27ebc8281cd.1555420166.git.kshcherbatov@tarantool.org> <4f44a278-a591-4fbf-b2fa-8cb50200d4b0@tarantool.org> Sender: tarantool-patches-bounce@freelists.org Errors-to: tarantool-patches-bounce@freelists.org Reply-To: tarantool-patches@freelists.org List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: tarantool-patches List-Subscribe: List-Owner: List-post: List-Archive: To: tarantool-patches@freelists.org Cc: Kirill Shcherbatov > On 7 May 2019, at 12:53, Kirill Shcherbatov = wrote: >=20 >=20 >> One unpleasant =E2=80=9Cfeature=E2=80=9D that I=E2=80=99ve noticed: >>=20 >> 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=E2=80=99 >>=20 >> 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 =E2=80=9Cfeature=E2=80=9D.