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

airborne pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-2.1 by this push:
     new 44c565840d9 [fix] (regression test) fix error tests (#39907)
44c565840d9 is described below

commit 44c565840d9fa825d77c330d87712dd15a3023ce
Author: Sun Chenyang <[email protected]>
AuthorDate: Mon Aug 26 17:48:52 2024 +0800

    [fix] (regression test) fix error tests (#39907)
    
    ## Proposed changes
    
    fix error tests: `test_dup_table_inverted_index`,
    `test_single_compaction_with_variant_inverted`
---
 ...test_single_compaction_with_variant_inverted_index.groovy | 12 ++++++------
 .../need_read_data/test_dup_table_inverted_index.groovy      | 11 ++---------
 2 files changed, 8 insertions(+), 15 deletions(-)

diff --git 
a/regression-test/suites/compaction/test_single_compaction_with_variant_inverted_index.groovy
 
b/regression-test/suites/compaction/test_single_compaction_with_variant_inverted_index.groovy
index 0e13662f3b4..788c3ad4608 100644
--- 
a/regression-test/suites/compaction/test_single_compaction_with_variant_inverted_index.groovy
+++ 
b/regression-test/suites/compaction/test_single_compaction_with_variant_inverted_index.groovy
@@ -208,11 +208,11 @@ suite("test_single_compaction_with_variant_inverted", 
"p2") {
     }
 
     sql """ INSERT INTO ${tableName} VALUES (1, "a", 100, '{"a" : 1234, 
"point" : 1, "xxxx" : "ddddd"}'); """
-    sql """ INSERT INTO ${tableName} VALUES (1, "b", 100, '{"%a" : 1234, 
"@point" : 1, "[xxxx" : "ddddd"}'); """
-    sql """ INSERT INTO ${tableName} VALUES (2, "a", 100, '{"@a" : 1234, 
"%point" : 1, "]xxxx" : "ddddd"}'); """
-    sql """ INSERT INTO ${tableName} VALUES (2, "b", 100, '{"%a" : 1234, 
"%point" : 1, "{xxxx" : "ddddd"}'); """
-    sql """ INSERT INTO ${tableName} VALUES (3, "a", 100, '{"@a" : 1234, 
"@point" : 1, "}xxxx" : "ddddd"}'); """
-    sql """ INSERT INTO ${tableName} VALUES (3, "b", 100, '{"a" : 1234, 
"point" : 1, "|xxxx" : "ddddd"}'); """
+    sql """ INSERT INTO ${tableName} VALUES (1, "b", 100, '{"%a" : 1234, 
"@point" : 1, "xxxx" : "ddddd"}'); """
+    sql """ INSERT INTO ${tableName} VALUES (2, "a", 100, '{"@a" : 1234, 
"%point" : 1, "xxxx" : "ddddd"}'); """
+    sql """ INSERT INTO ${tableName} VALUES (2, "b", 100, '{"%a" : 1234, 
"%point" : 1, "xxxx" : "ddddd"}'); """
+    sql """ INSERT INTO ${tableName} VALUES (3, "a", 100, '{"@a" : 1234, 
"@point" : 1, "xxxx" : "ddddd"}'); """
+    sql """ INSERT INTO ${tableName} VALUES (3, "b", 100, '{"a" : 1234, 
"point" : 1, "xxxx" : "ddddd"}'); """
 
     // trigger master be to do full compaction
     assertTrue(triggerCompaction(backendId_to_backendIP[master_backend_id], 
backendId_to_backendHttpPort[master_backend_id],
@@ -230,7 +230,7 @@ suite("test_single_compaction_with_variant_inverted", "p2") 
{
     checkTabletFileCrc.call()
 
     qt_sql """
-    select count() from  ${tableName} where properties MATCH_ANY 'point xxxx';
+    select count() from  ${tableName} where cast(properties['xxxx'] as string) 
MATCH_ANY 'ddddd';
     """
 
     sql """ DROP TABLE IF EXISTS ${tableName}; """
diff --git 
a/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
 
b/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
index 05d75cc540c..44f96d3aa6d 100644
--- 
a/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
+++ 
b/regression-test/suites/inverted_index_p1/need_read_data/test_dup_table_inverted_index.groovy
@@ -716,7 +716,7 @@ suite("test_dup_table_inverted_index", "p1") {
     
     
     try {
-         sql """ set enable_match_without_inverted_index = true """
+        sql """ set enable_match_without_inverted_index = true """
         sql """ set enable_common_expr_pushdown = true """
          def dupTableName = "dup_httplogs"
         sql """ drop table if exists ${dupTableName} """
@@ -795,14 +795,7 @@ suite("test_dup_table_inverted_index", "p1") {
         compare_result(dup_result5, dup_result6, all_dup_sql)
         compare_result(dup_result3, dup_result6, all_dup_sql)
 
-        def dup_result7 = 
execute_sql.call("enable_common_expr_pushdown_for_inverted_index", "true", 
all_dup_sql)
-        logger.info("dup_result7 is {}", dup_result7);
-        def dup_result8 = 
execute_sql.call("enable_common_expr_pushdown_for_inverted_index", "false", 
all_dup_sql)
-        logger.info("dup_result8 is {}", dup_result8);
-        compare_result(dup_result7, dup_result8, all_dup_sql)
-        compare_result(dup_result3, dup_result8, all_dup_sql)
-
-         def mowTable = "mow_httplogs"
+        def mowTable = "mow_httplogs"
         sql """ drop table if exists ${mowTable} """
         // create table
         sql """


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

Reply via email to