[tarantool-patches] Re: [PATCH 3/3] sql: fix passing FP values to integer iterator

[Konstantin Osipov]

* Nikita Pettik <korablev at tarantool.org> [19/05/24 20:42]:
> That happened due to the fact that type casting mechanism (OP_ApplyType)
> doesn't affect FP value when it is converted to integer. Hence, FP value
> was passed to the iterator over integer field which resulted in error.
> Meanwhile, comparison of integer and FP values is legal in SQL.  To cope
> with this problem for each equality comparison involving integer field
> we emit OP_MustBeInt, which checks whether value to be compared is
> integer or not. If the latter, we assume that result of comparison is
> always false and continue processing query. 

Are you sure other vendords would fail to return any results for
WHERE foo = 1.0?



-- 
Konstantin Osipov, Moscow, Russia