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

asked 2014-05-27 09:17:23 -0500

Piotr
31 ●7 ●12 ●12

edit retag flag offensive close merge delete

add a comment

2 Answers

Sort by » oldest newest most voted

Currently "in" is not supported for nested collection,and you should use the long format. however we plan adding this feature in next versions.

answered 2014-05-28 06:00:40 -0500

Ester
271 ●3 ●3

edit flag offensive delete link

Comments

Thanks for the answer. What about OR statement?

Thanks, Piotr

Piotr ( 2014-05-28 08:37:21 -0500 )edit

add a comment

If I am not wrong you are using a nested property feature that has been introduced recently (9.6?) are you sure the gs-ui you are using has already this feature?

answered 2014-05-28 02:51:07 -0500