This is an automated email from the ASF dual-hosted git repository. morningman pushed a commit to branch branch-1.2-lts in repository https://gitbox.apache.org/repos/asf/doris.git
commit 79352679d874ce43b1db4bef945e57914ceeab02 Author: luozenglin <[email protected]> AuthorDate: Tue Feb 28 10:57:37 2023 +0800 [test](regression) add some regression cases on constant evaluation. (#16599) --- regression-test/data/query_p0/subquery/test_subquery.out | 9 +++++++++ regression-test/suites/query_p0/subquery/test_subquery.groovy | 10 ++++++++++ 2 files changed, 19 insertions(+) diff --git a/regression-test/data/query_p0/subquery/test_subquery.out b/regression-test/data/query_p0/subquery/test_subquery.out index b9941ebf23..0af57d6613 100644 --- a/regression-test/data/query_p0/subquery/test_subquery.out +++ b/regression-test/data/query_p0/subquery/test_subquery.out @@ -15,3 +15,12 @@ -- !sql4 -- 1 +-- !sql6 -- + +-- !sql7 -- +1 -1 +2 -1 +3 -1 + +-- !sql8 -- + diff --git a/regression-test/suites/query_p0/subquery/test_subquery.groovy b/regression-test/suites/query_p0/subquery/test_subquery.groovy index 1044259929..2fdbe8dd54 100644 --- a/regression-test/suites/query_p0/subquery/test_subquery.groovy +++ b/regression-test/suites/query_p0/subquery/test_subquery.groovy @@ -41,4 +41,14 @@ suite("test_subquery") { select /*+SET_VAR(enable_projection=false) */ count() from (select k2, k1 from test_query_db.baseall order by k1 limit 1) a; """ + + qt_sql6 "select k1 from (select k1, -1 as c from test_query_db.test) t where t.c = 1;" + + qt_sql7 "select * from (select k1, -1 as c from test_query_db.test) t where t.c < 0 order by 1;" + + qt_sql8 """ + select * from (select k1, -1 as c from test_query_db.test union all select k1, -2 as c from test_query_db.baseall) t + where t.c > 0; + """ } + --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
