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

Ask Your Question
0

Exception "Logical error - query is always empty"

Hello,

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

1 Answer

Sort by ยป oldest newest most voted
0

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

Stats

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

Seen: 783 times

Last updated: Jun 05