This is an automated email from the ASF dual-hosted git repository.

morningman 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 2339dcda05 [fix](icebergv2)update icebergv2 regression case (#15442)
2339dcda05 is described below

commit 2339dcda058e832915cf2bbd39c9978752bb1093
Author: slothever <18522955+w...@users.noreply.github.com>
AuthorDate: Fri Dec 30 12:24:26 2022 +0800

    [fix](icebergv2)update icebergv2 regression case (#15442)
    
    update icebergv2 regression case
    Co-authored-by: jinzhe <jin...@selectdb.com>
---
 .../iceberg/test_external_catalog_icebergv2.out    | 24 +++++++++++-----------
 .../iceberg/test_external_catalog_icebergv2.groovy | 14 ++++++-------
 2 files changed, 19 insertions(+), 19 deletions(-)

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 7956396740..dd7d5cb2d5 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
@@ -9,28 +9,28 @@
 7
 
 -- !q03 --
-45132671
+8242263
 
 -- !q04 --
 0
 
 -- !q05 --
-1  Customer#000000001  IVhzIApeRb ot,c,E                        15  
25-989-741-2988     711.56  BUILDING      to the even, regular platelets. 
regular, ironic epitaphs nag e                                         |
-2  Customer#000000002  XSTf4,NCwDVaWNe6tEgvwfmRchLXak           13  
23-768-687-3665     121.65  AUTOMOBILE    l accounts. blithely ironic 
theodolites integrate boldly: caref                                        |
-3  Customer#000000003  MG9kdTD2WBHm                              1  
11-719-748-3364    7498.12  AUTOMOBILE     deposits eat slyly ironic, even 
instructions. express foxes detect slyly. blithely even accounts abov |
+1      Customer#000000001      IVhzIApeRb ot,c,E       15      25-989-741-2988 
711.56  BUILDING        to the even, regular platelets. regular, ironic 
epitaphs nag e
+3      Customer#000000003      MG9kdTD2WBHm    1       11-719-748-3364 7498.12 
AUTOMOBILE       deposits eat slyly ironic, even instructions. express foxes 
detect slyly. blithely even accounts abov
+4      Customer#000000004      XxVSJsLAGtn     4       14-128-190-5944 2866.83 
MACHINERY        requests. final, regular ideas sleep final accou
 
--- !q06 -
-366778465
-366778561
-366778657
+-- !q06 --
+604519555
+604519557
+604519558
 
 -- !q07 --
-10539361
-130424833
-2736865
+12979.65
+219204.52
+5908.20
 
 -- !q08 --
-1499999990
+120001848
 
 -- !q09 --
 1
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 a3a0511613..765bb789d5 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
@@ -33,14 +33,14 @@ suite("test_external_catalog_icebergv2", "p2") {
         sql """switch ${catalog_name};"""
         // test parquet format format
         def q01 = {
-            qt_q01 """ select count(1) as c from customer_small;"""
-            qt_q02 """ select c_custkey from customer_small group by c_custkey 
limit 4;"""
-            qt_q03 """ select count(1) from orders """
-            qt_q04 """ select count(1) from customer_small where c_name = 
'Customer#0063356' order by c_custkey limit 1; """
+            qt_q01 """ select count(1) as c from customer_small """
+            qt_q02 """ select c_custkey from customer_small group by c_custkey 
limit 4 """
+            qt_q03 """ select count(1) from orders_small """
+            qt_q04 """ select count(1) from customer_small where c_name = 
'Customer#000000005' or c_name = 'Customer#000000006' """
             qt_q05 """ select * from customer_small order by c_custkey limit 3 
"""
-            qt_q06 """ select o_orderkey from orders where o_orderkey > 652566 
limit 3"""
-            qt_q07 """ select o_orderkey from orders where o_custkey < 3357 
limit 3"""
-            qt_q08 """ select count(1) as c from customer;"""
+            qt_q06 """ select o_orderkey from orders_small where o_orderkey > 
652566 order by o_orderkey limit 3 """
+            qt_q07 """ select o_totalprice from orders_small where o_custkey < 
3357 order by o_custkey limit 3 """
+            qt_q08 """ select count(1) as c from customer """
         }
         // test time travel stmt
         def q02 = {


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to