Error while querying on nested collections
Hi All,
I have found very strange issue while querying data using web-ui (probably the same issue occurs while querying directly from code). Here are my "failing" queries:
select UID,* from Customer where rowNum<5000 and configuration.contacts[*](postcode.id = 5 OR postcode.id = 87)
select UID,* from Customer where rowNum<5000 and configuration.contacts[*](postcode.id IN (5,87))
The exception is:
2014-05-27 13:25:24,177 SEVERE [com.gigaspaces.webui.common] - com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "in" "IN "" at line 1, column 130.
Was expecting one of:
"like" ...
"not" ...
"<" ...
"<=" ...
">" ...
">=" ...
"=" ...
"!=" ...
"<>" ...
"(" ...
"[*]" ...
This is weird as the following query works fine:
select UID,* from Customer where rowNum<5000 and configuration.contacts[*](postcode.id = 5 AND postcode.id = 87)
contacts is a set of objects (Contact class). configuration and postcode are objects as well. id is an integer;
Any idea why it works that way?
I would be very thankful for any help!
Thanks, Piotr