You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by xi...@apache.org on 2024/07/12 11:59:17 UTC
(doris) branch master updated: [fix](Nereids) add order_qt in fuction groovy (#37542)
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: 谢健 <ji...@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-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org