SonarQube 5.2 Rest API: Can not search for groups that contain undersores

[Michael Binder]

Hi,

I am using the SonarQube 5.2 Rest API to create and query groups. My group names contain underscores e.g. "my_group".
A call to "/api/user_groups/search" finds this group. A call to "/api/user_groups/search?q=my_group" returns zero groups.

I traced the call in the sonarqube sources.
The GroupDao seems to escape undersores in the query. But the GroupMapper.xml does not declare an escape character in the query.

Possible solution:
Add "ESCAPE '/'" to the query. See also the correct implementation in GroupMembershipMapper.xml. Maybe this is an issue for other like queries.

suggestion for changes in GroupMapper.xml:

  <select id="selectByQuery" parameterType="map" resultType="Group">
    SELECT
    <include refid="groupColumns"/>
    FROM groups g
    WHERE UPPER(g.name) LIKE #{query} ESCAPE '/'
    ORDER BY UPPER(g.name)
  </select>

Please fix this bug.

Thank You!

Michael

[Teryk Bellahsene]

Hi,

Thanks a lot for the investigation! I confirm the bug.
Jira ticket created: https://jira.sonarsource.com/browse/SONAR-7163
It should be fixed in 5.3, out in January.

Sincerely,

Teryk

[liudo...@gmail.com]

Hi Teryk,

Here is the similar issue for api/users/search, if the logins parameter has unicode char or special char(eg. underscore, space), it will report error.

Please refer the topic: https://groups.google.com/forum/#!topic/sonarqube/AZ9eDLyBAMo

Thanks very much,

Dongshan

在 2015年12月23日星期三 UTC+8下午5:55:18，Teryk Bellahsene写道：

[michaelix...@gmail.com]

Hi,

tested with SonarQube 5.3. I can confirm this is fixed.

Thanks for the fast fix!