Hi,
I would try this:
where in (select * from table(foo int = (?)))
as described here: http://www.h2database.com/html/functions.html#table
If it doesn't work as expected, please tell us!
believe we can fix this relatively easy by allowing `IN ?` expression
where parameter is expected to
Currently this is not supported directly, though you can use TABLE function
( http://www.h2database.com/html/functions.html#table ) to workaround this
issue and write queries like this
select t.* from my_table t, table(id int = ?) z where t.id = z.id
and pass the array as parameter.
But this
Is there a way to parameterize the values in WHERE ... IN? Like IN (?).
I'm trying this, passing in an array of String, [Ljava.lang.String, but it
returns zero rows. Also tried passing [Ljava.lang.Object, with the same
result.
--
You received this message because you are subscribed to the
On Sun, Jun 14, 2015 at 8:40 PM, Sergi Vladykin
sergi.vlady...@gmail.com wrote:
But this question raises up often and I believe we can fix this relatively
easy by allowing `IN ?` expression where parameter is expected to be an
array. Thoughts?
That messes with optimising prepared statements
I also found this works:
where in (select * from table(foo int = (?)))
I recall that there are performance differences between 'in' clauses and
joins against table literals, though in practice I'm unable to predict
which will be best w/o testing with real data: it can go either way.
On