[Enhancement] enhance the stability of regression-test cases for aggregate-collect functions

[Hastyshell]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Description

@BiteTheDDDDt ran into regression-test failure seemed related to the test-case of aggregate functions collect_set and collect_list, for the reason of the order of vals in result array.

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]

Solution

Try to add some order-by limits to make it more stable.

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