SQLQuery IN collections on 10.0.1
So I was looking at the documentation for this @ http://docs.gigaspaces.com/xap100/que...
It says I can use a collection to fill a parametrised IN operator, however using very similar syntax does not work at all for me in 10.0.1 -
Collection<string> collection = new HashSet<string>();
collection.add("12345");
SQLQuery<myclass> query = new SQLQuery<myclass>(MyClass.class,"userId IN (?)");
query.setParameter(1, collection);
System.out.println(space.readMultiple(query).length);
== 0 Doesn't work
However...
SQLQuery<myclass> query = new SQLQuery<myclass>(MyClass.class,"userId = ?");
query.setParameter(1, "12345");
System.out.println(space.readMultiple(query).length);
==8562 Works
SQLQuery<myclass> query = new SQLQuery<myclass>(MyClass.class,"userId IN ('12345')");
System.out.println(space.readMultiple(query).length);
==8562 Works
Anyone able to confirm this either way? just checking I'm not missing anything.
Am simply injecting the values into the query string myself in the meantime...