Re: [Tarantool-discussions] Implicit cast for ASSIGNMENT

[Imeev Mergen <imeevma@tarantool.org>]

On 4/30/20 3:35 PM, Konstantin Osipov wrote:
> * Imeev Mergen <imeevma@tarantool.org> [20/04/30 15:13]:
>> 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.
> SQL is strictly typed, there should be no implicit conversions
> between numeric types.
>
> 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)?

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