You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@geode.apache.org by "Jinmei Liao (Jira)" <ji...@apache.org> on 2020/09/29 23:45:00 UTC
[jira] [Updated] (GEODE-8558) Pulse query is bypassing the
QueryResultSetLimit MBean parameter if there is a newline after query or
sql comments before the query line
[ 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)