From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <kostja.osipov@gmail.com>
Received: from mail-lf1-f68.google.com (mail-lf1-f68.google.com
 [209.85.167.68])
 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
 (No client certificate requested)
 by dev.tarantool.org (Postfix) with ESMTPS id B0F734696C3
 for <tarantool-discussions@dev.tarantool.org>;
 Thu, 30 Apr 2020 17:04:18 +0300 (MSK)
Received: by mail-lf1-f68.google.com with SMTP id b24so1313914lfp.7
 for <tarantool-discussions@dev.tarantool.org>;
 Thu, 30 Apr 2020 07:04:18 -0700 (PDT)
Date: Thu, 30 Apr 2020 17:04:14 +0300
From: Konstantin Osipov <kostja.osipov@gmail.com>
Message-ID: <20200430140414.GD6499@atlas>
References: <20200213142534.GA26443@tarantool.org>
 <36e21524-35d7-9f54-5953-32863df95709@tarantool.org>
 <20200430123500.GA6499@atlas>
 <8c71af0d-3693-82d5-4b15-f7b7fe38062c@tarantool.org>
 <20200430130947.GC6499@atlas>
 <2a788af3-6efe-bce8-1509-f7e08639b36f@tarantool.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <2a788af3-6efe-bce8-1509-f7e08639b36f@tarantool.org>
Subject: Re: [Tarantool-discussions] Implicit cast for ASSIGNMENT
List-Id: Tarantool development process
 <tarantool-discussions.dev.tarantool.org>
List-Unsubscribe: <https://lists.tarantool.org/mailman/options/tarantool-discussions>, 
 <mailto:tarantool-discussions-request@dev.tarantool.org?subject=unsubscribe>
List-Archive: <https://lists.tarantool.org/pipermail/tarantool-discussions/>
List-Post: <mailto:tarantool-discussions@dev.tarantool.org>
List-Help: <mailto:tarantool-discussions-request@dev.tarantool.org?subject=help>
List-Subscribe: <https://lists.tarantool.org/mailman/listinfo/tarantool-discussions>, 
 <mailto:tarantool-discussions-request@dev.tarantool.org?subject=subscribe>
To: Imeev Mergen <imeevma@tarantool.org>
Cc: tarantool-discussions@dev.tarantool.org

* Imeev Mergen <imeevma@tarantool.org> [20/04/30 16:14]:
> 
> On 4/30/20 4:09 PM, Konstantin Osipov wrote:
> > * Imeev Mergen <imeevma@tarantool.org> [20/04/30 15:59]:
> > > > The only possible exception is conversion of a lossless conversion
> > > > of a numeric literal, e.g.:
> > > > 
> > > > float_val = 1.1 -- implicitly convert decimal constant 1.1 to float
> > > So, is it fine to implicitly cast 1.0(DOUBLE) to 1(INTEGER)?
> > 1.0 is not double, it's DECIMAL.
> Ok, then, let's say we executed something like this:
> 
> box.execute('CREATE TABLE t (i INT PRIMARY KEY);')
> box.execute('INSERT INTO t VALUES(CAST(1 AS DOUBLE));')
> 
> Should this work of we should receive an error?

I think it shouldn't because CAST(1 AS DOUBLE) is an expression,
not a constant literal.

-- 
Konstantin Osipov, Moscow, Russia
https://scylladb.com