Template for a good bug report, formatted with Markdown:
- versions used: SonarQube 7.9
- error observed:
when call create group api with same group name at the same time,
will create duplicate group
- steps to reproduce
- potential workaround
- not add db constraint on table groups columns name
schema: sonarqube/schema-sq.ddl at 4b24dd9c4060ef27950440249b1a279b02e9405b · SonarSource/sonarqube · GitHub
history reason: (MySQL cannot create a unique index on a UTF-8 VARCHAR larger than 255 characters on InnoDB ) sonarqube/GroupWsSupport.java at 4fc4a5853354a00e80f1e27556385e4338b57cd0 · SonarSource/sonarqube · GitHub - table groups column name max length limit in code is 255, but in db limit is 500
in code: sonarqube/UserGroupValidation.java at 3f6f5496277c76c2498fd245a112931d19830497 · SonarSource/sonarqube · GitHub
in db: sonarqube/schema-sq.ddl at 4b24dd9c4060ef27950440249b1a279b02e9405b · SonarSource/sonarqube · GitHub
can we migrate table groups change column name limit max length 255, and add uniq constraint in next version?
thanks you