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 -0500

Alexey Serdyuk's avatar
edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

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 -0500

Dixson Huie's avatar
edit flag offensive delete link more

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

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

Alexey Serdyuk's avatar
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 -0500

Seen: 1,450 times

Last updated: May 29 '19