This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 7584467115c [fix](Nereids) add order_qt in fuction groovy (#37542)
(#38038)
7584467115c is described below
commit 7584467115cf0ad3d7e78dfa9d3f938305f58957
Author: 谢健 <[email protected]>
AuthorDate: Thu Jul 18 14:16:45 2024 +0800
[fix](Nereids) add order_qt in fuction groovy (#37542) (#38038)
pick from master #37542
---
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 dcab3f5fec1..951931fed55 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: [email protected]
For additional commands, e-mail: [email protected]
