[
https://issues.apache.org/jira/browse/GEODE-8558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jinmei Liao updated GEODE-8558:
-------------------------------
Description: Setting the JVM MBean attribute QueryResultSetLimit to limit
the query result set (e.g. 2 here with my small local cluster) and it seems
working, however, in the pulse query textbox, if you have a
carriage-return/newline after query line or let's say a commented text/query
before the actual query, it's returning all the entries and the setting is not
effective anymore. And if this could also affect the queries running with
commented text coming from function execution. (was: Setting the JVM MBean
attribute QueryResultSetLimit to limit the query result set (e.g. 2 here with
my small local cluster) and it seems working, however, in the pulse query
textbox, if you have a carriage-return/newline after query line or let's say a
commented text/query before the actual query, it's returning all the entries
and the setting is not effective anymore. And if this could also affect the
queries running with commented text coming from function execution.
A customer came with this log entry and was asking if there is a way to limit
this, and you can see where it's bypassing the default limit of 1000 for this
MBean param and putting cluster down since there is no limit as it's trying to
return everything towards the query executed from the pulse.)
> Pulse query is bypassing the QueryResultSetLimit MBean parameter if there is
> a newline after query or sql comments before the query line
> ----------------------------------------------------------------------------------------------------------------------------------------
>
> Key: GEODE-8558
> URL: https://issues.apache.org/jira/browse/GEODE-8558
> Project: Geode
> Issue Type: Bug
> Components: querying
> Affects Versions: 1.13.0
> Reporter: Jinmei Liao
> Priority: Major
>
> Setting the JVM MBean attribute QueryResultSetLimit to limit the query result
> set (e.g. 2 here with my small local cluster) and it seems working, however,
> in the pulse query textbox, if you have a carriage-return/newline after query
> line or let's say a commented text/query before the actual query, it's
> returning all the entries and the setting is not effective anymore. And if
> this could also affect the queries running with commented text coming from
> function execution.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
