[Tarantool-discussions] Implicit cast for ASSIGNMENT

Imeev Mergen imeevma at tarantool.org
Thu Apr 30 15:04:11 MSK 2020

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
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?

More information about the Tarantool-discussions mailing list