From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <kyukhin@tarantool.org>
Received: from smtp56.i.mail.ru (smtp56.i.mail.ru [217.69.128.36])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (No client certificate requested)
 by dev.tarantool.org (Postfix) with ESMTPS id 20EB5469710
 for <tarantool-discussions@dev.tarantool.org>;
 Fri,  8 May 2020 14:57:57 +0300 (MSK)
Date: Fri, 8 May 2020 14:57:54 +0300
From: Kirill Yukhin <kyukhin@tarantool.org>
Message-ID: <20200508115754.v6ss2a6u2zqwo2q4@tarantool.org>
References: <20200213142534.GA26443@tarantool.org>
 <36e21524-35d7-9f54-5953-32863df95709@tarantool.org>
 <e2d9ebaf-2609-d304-b4dd-debc779af2a8@ocelot.ca>
 <37b646d1-39a3-f39a-c436-f315fe1359a0@tarantool.org>
 <3baee836-8404-bfaf-1c3a-353a379861d0@ocelot.ca>
 <a41c1c2d-b9dc-5f81-40ef-d40fabd80041@ocelot.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <a41c1c2d-b9dc-5f81-40ef-d40fabd80041@ocelot.ca>
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: Peter Gulutzan <pgulutzan@ocelot.ca>
Cc: tarantool-discussions@dev.tarantool.org

Hello,

On 07 май 10:14, Peter Gulutzan wrote:
> Update: K. Yukhin has re-opened
> issue#4216 Silent NUMBER cast to INTEGER
> https://github.com/tarantool/tarantool/issues/4216
> and K. Osipov wrote:
> > OK, I didn't know it's ANSI. I withdraw my previous remarks and
> > side with Peter. Please do as he says about implicit casts of
> > numeric types.
> 
> Therefore I believe that everyone agrees with you,
> "Values ​​of numeric types can be implicitly cast to other numeric"
> for assignments.

I guess so.
 
> Therefore ...
> 
> This will be true for anything that has a numeric data type,
> now or in the planned future
> (DECIMAL, DOUBLE, INTEGER, NUMBER, UNSIGNED).
> 
> Maybe this will be true for STRING.
> UPDATE table_name SET integer_column = '1.1';
> I said that is bad but I don't decide.

I don't like the idea. We were talking about NUMBERIC-NUMERIC
conversions.

--
Regards, Kirill Yukhin