about replication of SQLquery template

edit

I have an Object (call Data) with just one Integer member - id. id is SpaceRoute.

Now, I have a data grid using 2 partitioned spaces. the first space will contain object with even hash the second space will contain object with odd hash

If I notify new Data(), both space got the template

if I notify new SQLQuery<data>(new Data(),"id < 10"), first space got the template. if I notify new SQLQuery<data>(new Data(),"id < 9"), second space got the template.

if I notify new SQLQuery<data>(new Data(),"id < 9 and id < 10"), second space got the template. if I notify new SQLQuery<data>(new Data(),"id < 10 and id < 9"), second space got the template.

if I notify new SQLQuery<data>(new Data(),"id < 11 and id < 10"), first space got the template. if I notify new SQLQuery<data>(new Data(),"id < 10 and id < 11"), first space got the template.

Is this a bug in SQLQuery ??

Edited by: Tsui Chi wing on Feb 26, 2009 9:35 PM

id < 9 and id < 10 means id < 9

Why you need such a query?

Maybe what you means is this: id > 8 and id < 10

Note the notify template does have some limitations when using SQLQuery. See: http://www.gigaspaces.com/wiki/displa...

Shay

Maybe we should focus on the question "Why I notify new SQLQuery<data>(new Data(),"id < 10"), only first space got the template".

You should see the notify template at each partition. Can you check the gs-ui , space-browser , classes view and see how many templates each partition has?

Shay

According to the reply dated Feb 26, 2009 9:35 PM,

if I notify new SQLQuery<data>(new Data(),"id < 10"), only first space got the template. That means only one template present. if I notify new SQLQuery<data>(new Data(),"id < 9"), only second space got the template. That means only one template present.

This result is given by the output form gs-ui , space-browser , classes view.