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.