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


The following commit(s) were added to refs/heads/branch-1.2-lts by this push:
     new 485e8c9d79 [branch1.2](test) modify some test cases
485e8c9d79 is described below

commit 485e8c9d793d5e6cec512c9d753cc75037358076
Author: morningman <[email protected]>
AuthorDate: Mon Aug 14 23:14:10 2023 +0800

    [branch1.2](test) modify some test cases
---
 .../test_create_table_with_bloom_filter.out          | 20 ++++++++++----------
 regression-test/data/index_p0/test_bitmap_index.out  |  6 +++---
 .../suites/query_p0/aggregate/analytic_expr.groovy   |  3 ++-
 .../aggregate/push_filter_through_agg.groovy         |  4 +++-
 4 files changed, 18 insertions(+), 15 deletions(-)

diff --git 
a/regression-test/data/bloom_filter_p0/test_create_table_with_bloom_filter.out 
b/regression-test/data/bloom_filter_p0/test_create_table_with_bloom_filter.out
index 622c33fde3..06e477015c 100644
--- 
a/regression-test/data/bloom_filter_p0/test_create_table_with_bloom_filter.out
+++ 
b/regression-test/data/bloom_filter_p0/test_create_table_with_bloom_filter.out
@@ -11,11 +11,11 @@ char_50_key CHAR(50)        No      true    \N      
BLOOM_FILTER
 character_key  VARCHAR(500)    No      true    \N      BLOOM_FILTER
 char_key       CHAR(1) No      true    \N      BLOOM_FILTER
 character_most_key     VARCHAR(65533)  No      true    \N      BLOOM_FILTER
-decimal_key    DECIMAL(20,6)   No      true    \N      BLOOM_FILTER
-decimal_most_key       DECIMAL(27,9)   No      true    \N      BLOOM_FILTER
-decimal32_key  DECIMALV3(5,1)  No      true    \N      BLOOM_FILTER
-decimal64_key  DECIMALV3(14,1) No      true    \N      BLOOM_FILTER
-decimal128_key DECIMALV3(38,1) No      true    \N      BLOOM_FILTER
+decimal_key    DECIMALV3(20,6) No      true    \N      BLOOM_FILTER
+decimal_most_key       DECIMALV3(27,9) No      true    \N      BLOOM_FILTER
+decimal32_key  DECIMALV3V3(5,1)        No      true    \N      BLOOM_FILTER
+decimal64_key  DECIMALV3V3(14,1)       No      true    \N      BLOOM_FILTER
+decimal128_key DECIMALV3V3(38,1)       No      true    \N      BLOOM_FILTER
 date_key       DATE    No      true    \N      BLOOM_FILTER
 datetime_key   DATETIME        No      true    \N      BLOOM_FILTER
 datev2_key     DATE    No      true    \N      BLOOM_FILTER
@@ -30,11 +30,11 @@ char_50_value       CHAR(50)        No      false   \N      
REPLACE
 character_value        VARCHAR(500)    No      false   \N      REPLACE
 char_value     CHAR(1) No      false   \N      REPLACE
 character_most_value   VARCHAR(65533)  No      false   \N      REPLACE
-decimal_value  DECIMAL(20,6)   No      false   \N      SUM
-decimal_most_value     DECIMAL(27,9)   No      false   \N      SUM
-decimal32_value        DECIMALV3(5,1)  No      false   \N      SUM
-decimal64_value        DECIMALV3(14,1) No      false   \N      SUM
-decimal128_value       DECIMALV3(38,1) No      false   \N      SUM
+decimal_value  DECIMALV3(20,6) No      false   \N      SUM
+decimal_most_value     DECIMALV3(27,9) No      false   \N      SUM
+decimal32_value        DECIMALV3V3(5,1)        No      false   \N      SUM
+decimal64_value        DECIMALV3V3(14,1)       No      false   \N      SUM
+decimal128_value       DECIMALV3V3(38,1)       No      false   \N      SUM
 date_value_max DATE    No      false   \N      MAX
 date_value_replace     DATE    No      false   \N      REPLACE
 date_value_min DATE    No      false   \N      MIN
diff --git a/regression-test/data/index_p0/test_bitmap_index.out 
b/regression-test/data/index_p0/test_bitmap_index.out
index 10f25b0af9..db40247254 100644
--- a/regression-test/data/index_p0/test_bitmap_index.out
+++ b/regression-test/data/index_p0/test_bitmap_index.out
@@ -9,7 +9,7 @@ k6      VARCHAR(1)      Yes     false   \N      NONE
 k7     DATE    Yes     false   \N      NONE
 k8     DATETIME        Yes     false   \N      NONE
 k9     LARGEINT        Yes     false   \N      NONE
-k10    DECIMAL(9,0)    Yes     false   \N      NONE
+k10    DECIMALV3(9,0)  Yes     false   \N      NONE
 k11    BOOLEAN Yes     false   \N      NONE
 k12    DATE    Yes     false   \N      NONE
 k13    DATETIME        Yes     false   \N      NONE
@@ -46,7 +46,7 @@ k6    VARCHAR(1)      Yes     true    \N
 k7     DATE    Yes     true    \N      
 k8     DATETIME        Yes     true    \N      
 k9     LARGEINT        Yes     true    \N      
-k10    DECIMAL(9,0)    Yes     true    \N      
+k10    DECIMALV3(9,0)  Yes     true    \N      
 k11    BOOLEAN Yes     true    \N      
 k12    DATE    Yes     true    \N      
 k13    DATETIME        Yes     true    \N      
@@ -84,7 +84,7 @@ k6    VARCHAR(1)      Yes     true    \N
 k7     DATE    Yes     true    \N      
 k8     DATETIME        Yes     true    \N      
 k9     LARGEINT        Yes     true    \N      
-k10    DECIMAL(9,0)    Yes     true    \N      
+k10    DECIMALV3(9,0)  Yes     true    \N      
 k11    BOOLEAN Yes     true    \N      
 k12    DATE    Yes     false   \N      REPLACE
 k13    DATETIME        Yes     false   \N      REPLACE
diff --git a/regression-test/suites/query_p0/aggregate/analytic_expr.groovy 
b/regression-test/suites/query_p0/aggregate/analytic_expr.groovy
index 89c9e02f64..dff2db29c5 100644
--- a/regression-test/suites/query_p0/aggregate/analytic_expr.groovy
+++ b/regression-test/suites/query_p0/aggregate/analytic_expr.groovy
@@ -18,6 +18,7 @@
  */
 
 suite("analytic_expr_test") {
+    sql """drop table if exists test_load_03;"""
     sql """
         CREATE TABLE `test_load_03` (
           `id` varchar(10) NULL,
@@ -53,4 +54,4 @@ suite("analytic_expr_test") {
             lead(ctime,1,0) over(partition by id order by ctime) as lead_ctime
         from test_load_03; 
     """
-}
\ No newline at end of file
+}
diff --git 
a/regression-test/suites/query_p0/aggregate/push_filter_through_agg.groovy 
b/regression-test/suites/query_p0/aggregate/push_filter_through_agg.groovy
index 82ee73c4f2..9cd42c7b17 100644
--- a/regression-test/suites/query_p0/aggregate/push_filter_through_agg.groovy
+++ b/regression-test/suites/query_p0/aggregate/push_filter_through_agg.groovy
@@ -16,6 +16,7 @@
 // under the License.
 
 suite("push_filter_through_agg") {
+    sql """drop table if exists t_push_filter_through_agg;"""
     sql """
         CREATE TABLE t_push_filter_through_agg (col1 varchar(11451) not null, 
col2 int not null, col3 int not null)
         UNIQUE KEY(col1)
@@ -26,6 +27,7 @@ suite("push_filter_through_agg") {
         );
     """
 
+    sql """drop view if exists view_i;"""
     sql """
         CREATE VIEW `view_i` AS 
         SELECT 
@@ -56,4 +58,4 @@ suite("push_filter_through_agg") {
      qt_sql """
          SELECT SUM(`col2`) FROM view_i WHERE `col1` BETWEEN 10 AND 20 LIMIT 1;
      """
-}
\ No newline at end of file
+}


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to