You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2023/04/19 13:35:01 UTC
[doris] 35/36: [regression-test](iceberg)add iceberg in regression case (#18792)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-2.0-alpha
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 563900e23dad149f9b0d022475b862855d41c404
Author: slothever <18...@users.noreply.github.com>
AuthorDate: Wed Apr 19 15:09:20 2023 +0800
[regression-test](iceberg)add iceberg in regression case (#18792)
add iceberg 'in' clause regression case
for #18226
---
.../iceberg/test_external_catalog_icebergv2.out | 8 ++++++++
.../iceberg/test_external_catalog_icebergv2.groovy | 6 ++++++
2 files changed, 14 insertions(+)
diff --git a/regression-test/data/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.out b/regression-test/data/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.out
index e7158ffd36..cbabc8ecec 100644
--- a/regression-test/data/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.out
+++ b/regression-test/data/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.out
@@ -52,3 +52,11 @@
149999999
149999996
+-- !q13 --
+1
+4
+7
+
+-- !q14 --
+Customer#000000004
+Customer#000000007
diff --git a/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy b/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
index 3b70f1936e..c4e18d4b99 100644
--- a/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
+++ b/regression-test/suites/external_table_emr_p2/iceberg/test_external_catalog_icebergv2.groovy
@@ -49,8 +49,14 @@ suite("test_external_catalog_icebergv2", "p2") {
qt_q11 """ select c_custkey from customer for version as of 906874575350293177 order by c_custkey limit 3 """
qt_q12 """ select c_custkey from customer for version as of 6352416983354893547 order by c_custkey desc limit 3 """
}
+ // in predicate
+ def q03 = {
+ qt_q13 """ select c_custkey from customer_small where c_custkey in (1, 2, 4, 7) order by c_custkey """
+ qt_q14 """ select c_name from customer_small where c_name in ('Customer#000000004', 'Customer#000000007') order by c_custkey """
+ }
sql """ use `tpch_1000_icebergv2`; """
q01()
q02()
+ q03()
}
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org