[
https://issues.apache.org/jira/browse/QPID-8691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17948476#comment-17948476
]
ASF GitHub Bot commented on QPID-8691:
--------------------------------------
vavrtom merged PR #277:
URL: https://github.com/apache/qpid-broker-j/pull/277
> [Broker-J] Increased CPU usage during query evaluation
> ------------------------------------------------------
>
> Key: QPID-8691
> URL: https://issues.apache.org/jira/browse/QPID-8691
> Project: Qpid
> Issue Type: Bug
> Components: Broker-J
> Affects Versions: qpid-java-broker-9.2.1
> Reporter: Daniil Kirilyuk
> Priority: Minor
> Fix For: qpid-java-broker-10.0.0
>
>
> Following query sent on endpoint
> POST /api/latest/querybroker/broker
> increases CPU consumption depending on count of '%' character in prefix of
> like clause:
> {code:java}
> select count(id) as cnt from queue where upper(name) like ('%%%%%%%xxx%')
> {code}
> Same behavior is observed when calling endpoint
> GET /api/latest/querybroker/queue?select=id,name,id&where=name like
> '%%%%%%xxx%'&offset=0&limit=100
> *Implementation*
> Multiple consecutive {{%}} characters are reduced to a single {{%}} character
> in {{ComparisonExpression}} within the {{broker-core}} module and
> {{LikeExpression}} within the {{query-engine}} plugin.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
