[tarantool-patches] Re: [PATCH] sql: make IN operator stop ignoring type and collation

[Kirill Yukhin]

Hello,

On 16 Jan 16:34, Nikita Pettik wrote:
> SQLite discards type and collation of IN operator when it comes with
> only one operand. This leads to different results of straight comparison
> using '=' operator and IN:
> 
> SELECT x FROM t1 WHERE x IN (1.0);
> -- Result is empty set
> SELECT x FROM t1 WHERE x = 1.0;
> - - ['1']
> 
> Lets remove this strange ignorance and always take into consideration
> types and collations of operands.
> 
> Closes #3934
> ---
> Branch: https://github.com/tarantool/tarantool/tree/np/gh-3934-IN-operator-fix
> Issue: https://github.com/tarantool/tarantool/issues/3934

I've checked your patch into 2.1 branch.

--
Regards, Kirill Yukhin