Re: [Tarantool-discussions] Implicit cast for ASSIGNMENT

[Imeev Mergen <imeevma@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?
>