[
https://issues.apache.org/jira/browse/QPID-8691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tomas Vavricka updated QPID-8691:
---------------------------------
Description:
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.
was:
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
> [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]
