[Tarantool-discussions] Implicit cast for ASSIGNMENT
imeevma at tarantool.org
Thu Apr 30 15:56:51 MSK 2020
On 4/30/20 3:35 PM, Konstantin Osipov wrote:
> * Imeev Mergen <imeevma at 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
> 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.
More information about the Tarantool-discussions