Re: sql in clause conversion from H2 to Calcite

[MJ]

Ignite 2.16


Thanks,
MJ


         Original
         
       
From:Stephen Darlington <sdarling...@apache.org&gt;
Sent Time:2025-03-17- 20:00
To:user <user@ignite.apache.org&gt;
Subject:Re: sql in clause conversion from H2 to Calcite



Are you using Ignite 2 or Ignite 3?

On Mon, 17 Mar 2025 at 11:15, MJ <6733...@qq.com&gt; wrote:
Hi,


Any idea how to convert H2's in clause sql to Calcite version ?&nbsp; For H2, 
the sql - select * from tbl where col in (select col from (table col varchar = 
?)) works well with array objects as parameter . Is there the similar for 
Calcite ?




Thanks,
MJ