[ 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: dev-unsubscr...@qpid.apache.org For additional commands, e-mail: dev-h...@qpid.apache.org