[ 
https://issues.apache.org/jira/browse/QPID-8691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17948477#comment-17948477
 ] 

ASF subversion and git services commented on QPID-8691:
-------------------------------------------------------

Commit ed0ca8759ae79b597c889d14a468107944641d34 in qpid-broker-j's branch 
refs/heads/main from Daniil Kirilyuk
[ https://gitbox.apache.org/repos/asf?p=qpid-broker-j.git;h=ed0ca8759a ]

QPID-8691: [Broker-J] Increased CPU usage during query evaluation (#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: dev-unsubscr...@qpid.apache.org
For additional commands, e-mail: dev-h...@qpid.apache.org

Reply via email to