1. [MINOR][TEST][SQL] Make in-limit.sql more robust (details)
Commit 2227a166782797f0e47a5d850b9713829300a466 by gurwls223
[MINOR][TEST][SQL] Make in-limit.sql more robust
### What changes were proposed in this pull request?
For queries like `t1d in (SELECT t2d FROM  t2 ORDER  BY t2c LIMIT 2)`,
the result can be non-deterministic as the result of the subquery may
output different results (it's not sorted by `t2d` and it has shuffle).
This PR makes the test more robust by sorting the output column.
### Why are the changes needed?
avoid flaky test
### Does this PR introduce _any_ user-facing change?
### How was this patch tested?
Closes #28976 from cloud-fan/small.
Authored-by: Wenchen Fan <> Signed-off-by:
HyukjinKwon <>
(cherry picked from commit f83415629b18d628f72a32285f0afc24f29eaa1e)
Signed-off-by: HyukjinKwon <>
The file was modifiedsql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-limit.sql.out (diff)
The file was modifiedsql/core/src/test/resources/sql-tests/inputs/subquery/in-subquery/in-limit.sql (diff)