jacktengg opened a new issue, #11318: URL: https://github.com/apache/doris/issues/11318
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version master b260a0221 ### What's Wrong? query result is wrong, expected: ``` \N \N 103 255 1001 1986, 1989 1002 1989, 32767 3021 1991, 1992, 32767 5014 1985, 1991 25699 1989 2147483647 255, 1991, 32767, 32767 ``` actual result: ``` +------------+----------------------------------------------------------------------+ | abs(`k3`) | group_concat(CAST(abs(`k2`) AS CHARACTER), ORDER BY abs(`k2`), `k1`) | +------------+----------------------------------------------------------------------+ | NULL | NULL | | 103 | 255 | | 1001 | 1986, 1989 | | 1002 | 1989, 32767 | | 3021 | 1991, 1991, 32767 | | 5014 | 1985, 1991 | | 25699 | 1989 | | 2147483647 | 255, 255, 255, 32767 | +------------+----------------------------------------------------------------------+ ``` or ``` +------------+----------------------------------------------------------------+ | abs(`k3`) | group_concat(CAST(abs(`k2`) AS CHARACTER), ORDER BY abs(`k2`)) | +------------+----------------------------------------------------------------+ | NULL | NULL | | 103 | 255 | | 1001 | 1986, 1989 | | 1002 | 1989, 32767 | | 3021 | 1991, 1992, 32767 | | 5014 | 1985, 1991 | | 25699 | 1989 | | 2147483647 | 255, 255, 255, 32767 | +------------+----------------------------------------------------------------+ ``` ### What You Expected? result is OK ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
