From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from smtp45.i.mail.ru (smtp45.i.mail.ru [94.100.177.105]) (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 7581E4696C3 for ; Thu, 30 Apr 2020 15:04:14 +0300 (MSK) From: Imeev Mergen References: <20200213142534.GA26443@tarantool.org> Message-ID: <36e21524-35d7-9f54-5953-32863df95709@tarantool.org> Date: Thu, 30 Apr 2020 15:04:11 +0300 MIME-Version: 1.0 In-Reply-To: <20200213142534.GA26443@tarantool.org> Content-Type: text/plain; charset="utf-8"; format="flowed" Content-Transfer-Encoding: 8bit Content-Language: en-US Subject: Re: [Tarantool-discussions] Implicit cast for ASSIGNMENT List-Id: Tarantool development process List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , To: tarantool-discussions@dev.tarantool.org, kostja.osipov@gmail.com, pgulutzan@ocelot.ca, korablev@tarantool.org, alexander.turenko@tarantool.org, v.shpilevoy@tarantool.org, kyukhin@tarantool.org, tsafin@tarantool.org Hi! Here we go again. Last time we have not come to a colclusion. So, I suggest these rules for implicit cast for ASSIGNMENT: 1) Any value can be implicitly cast to ANY type. 2) Any scalar values ​​can be implicitly cast to SCALAR type. 3) Values ​​of numeric types can be implicitly cast to other numeric types. 4) Implicit casting is prohibited, except as described above. I think that the rules for implicit casting when assigning value of numeric type must be the same as in C. On 2/13/20 5:25 PM, Mergen Imeev wrote: > Hi all, > I would like to discuss the second issue of casts in SQL. I mean > implicit casting for ASSIGNMENT. > > For now, I suggest avoiding questions about SCALAR, as the > discussion is already in progress. > > So, I suggest removing the current implicit casts. We can > reimplement implicit casts in accordance with ANSI in issue #3836. > But since priority of #3836 is low, this is most likely not going > to happen for some time. > > At the moment, I see two ways to remove implicit casts: > 1) Disable all implicit casts, except casts for numeric values. > These casts will become UDCF later. > 2) Disable all implicit casts. Assignment in Tarantool-SQL will > work the same as in noSQL Tarantool. > > What do you think about this? >