This is an automated email from the ASF dual-hosted git repository.
xiejiann pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 24b41fcd0b6 [fix](Nereids) add order_qt in fuction groovy (#37542)
24b41fcd0b6 is described below
commit 24b41fcd0b66eb0a439f6a8f1e48832bb9380d38
Author: 谢健 <jianx...@gmail.com>
AuthorDate: Fri Jul 12 19:59:09 2024 +0800
[fix](Nereids) add order_qt in fuction groovy (#37542)
## Proposed changes
use `order_qt` to avoid unstable order of output in the
`function.groovy`
---
regression-test/suites/nereids_syntax_p0/function.groovy | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/regression-test/suites/nereids_syntax_p0/function.groovy
b/regression-test/suites/nereids_syntax_p0/function.groovy
index 41e6309aabe..3ca00abfcd6 100644
--- a/regression-test/suites/nereids_syntax_p0/function.groovy
+++ b/regression-test/suites/nereids_syntax_p0/function.groovy
@@ -86,9 +86,9 @@ suite("nereids_function") {
result([[0L, 0L], [1L, 1L], [2L, 2L], [3L, 3L], [4L, 4L], [5L, 5L],
[6L, 6L], [7L, 7L], [8L, 8L], [9L, 9L]])
}
- qt_subquery1 """ select * from numbers("number" = "10") where number =
(select number from numbers("number" = "10") where number=1); """
- qt_subquery2 """ select * from numbers("number" = "10") where number in
(select number from numbers("number" = "10") where number>5); """
- qt_subquery3 """ select a.number from numbers("number" = "10") a where
number in (select number from numbers("number" = "10") b where
a.number=b.number); """
+ order_qt_subquery1 """ select * from numbers("number" = "10") where number
= (select number from numbers("number" = "10") where number=1); """
+ order_qt_subquery2 """ select * from numbers("number" = "10") where number
in (select number from numbers("number" = "10") where number>5); """
+ order_qt_subquery3 """ select a.number from numbers("number" = "10") a
where number in (select number from numbers("number" = "10") b where
a.number=b.number); """
test {
sql """select `number` from numbers("number" = "-1")"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
