Welcome to the new Gigaspaces XAP forum. To recover your account, please follow these instructions.

Ask Your Question

Exception "Logical error - query is always empty"


when processing a query parameterized by a customer-supplied search criteria, we have received a GigaSpace exception "Logical error - query is always empty - fix your SQL syntax". The customer had indeed supplied parameters which could never return any values, something similar to "myProperty < 3 AND myProperty > 100".

Although the exception is correct - this query indeed is always empty - I would prefer to return an empty result to the customer instead of dealing with an exception or analyzing the supplied search criteria for plausibility. Is there any option / flag which allows to execute such queries with an empty result instead of throwing an exception?

By the way, every "classical" database I know would just execute the query and return an empty result. One could argue if the exception is better or not, but it is definitely violates a principle of a least surprise.

asked 2017-06-02 09:33:44 -0600

Alexey Serdyuk gravatar image
edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

Hi, could you please let us know if this was fixed in the meantime.

answered 2019-05-29 09:35:04 -0600

Alexey Serdyuk gravatar image
edit flag offensive delete link more

There is no flag that will change the behavior to return an empty result set instead of throwing an exception.

I have created a JIRA to track this feature request. Please open a support case if you would like to be notified when/if there is progress to this request.

answered 2017-06-05 08:41:29 -0600

Dixson Huie gravatar image
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower


Asked: 2017-06-02 09:33:44 -0600

Seen: 1,363 times

Last updated: May 29 '19