TangSiyang2001 commented on PR #15339: URL: https://github.com/apache/doris/pull/15339#issuecomment-1447971661
> Hi, Does the case in this pr need to add some `order by` to ensure that the results are always consistent? I'm running into something that looks like it's sorting related. > > ``` > 2023-02-28 16:58:32.363 ERROR [suite-thread-3] (ScriptContext.groovy:121) - Run test_aggregate_collect in /doris/regression-test/suites/query_p0/sql_functions/aggregate_functions/test_aggregate_collect.groovy failed > java.lang.IllegalStateException: Check tag 'select' failed: > Check tag 'select' failed, line 1, CHAR result mismatch. > Expect cell is: [1555555555, 3555555555, 9555555555, 255555555, 55555555555] > But real is: [1555555555, 9555555555, 3555555555, 255555555, 55555555555] > ``` It seems so, I will add `order_by` to ensure the stability. -- 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 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