leric opened a new issue, #5484: URL: https://github.com/apache/incubator-devlake/issues/5484
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened Code blocks of an issue all have same line numbers.  In ConvertIssueCodeBlocks function, query didn't specify select clause, _tool_sonarqube_issue_code_blocks and _tool_sonarqube_issues have overlap columns, end up selected start_line, end_line, start_offset, end_offset from _tool_sonarqube_issues, cause line range columns in cq_issue_code_blocks have same numbers from _tool_sonarqube_issues. ### What do you expect to happen Code blocks should have different line ranges, confirmed in sonarqube. ### How to reproduce sync any sonarqube project, find an issue with multiple code blocks. ### Anything else _No response_ ### Version v0.17 ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
