[Tarantool-patches] [PATCH v3 4/8] sql: replace ApplyType by CheckType for IN operator

Nikita Pettik korablev at tarantool.org
Mon Jun 29 15:56:30 MSK 2020


On 25 Jun 18:17, imeevma at tarantool.org wrote:
> index f7681640e..a2147b0e8 100755
> --- a/test/sql-tap/in3.test.lua
> +++ b/test/sql-tap/in3.test.lua
> @@ -1,6 +1,6 @@
>  #!/usr/bin/env tarantool
>  test = require("sqltester")
> -test:plan(29)
> +test:plan(28)
>  
>  --!./tcltestrunner.lua
>  -- 2007 November 29
> @@ -322,18 +322,6 @@ test:do_test(
>          -- </in3-3.2>
>      })
>  
> -test:do_test(
> -    "in3-3.3",
> -    function()
> -        -- Logically, numeric affinity is applied to both sides before
> -        -- the comparison, but index can't be used.
> -        return exec_neph(" SELECT x IN (SELECT b FROM t1) FROM t2 ")
> -    end, {
> -        -- <in3-3.3>
> -        1, true
> -        -- </in3-3.3>
> -    })
> -

I'd rather not drop this test. It's about scalar-numeric types
interaction. Mb it is not the most suitable place for such test,
but make sure this scenario is covered somewhere else.

The rest is OK as obvious.



More information about the Tarantool-patches mailing list