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

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

commit 8217ae6beaf257e5da95d3c27d449904f87a319c
Author: Sun Chenyang <[email protected]>
AuthorDate: Mon Sep 2 20:15:07 2024 +0800

    [fix] (regression test) fix error test (#40098)
    
    fix error test: `test_single_compaction_with_variant_inverted`
---
 ...t_single_compaction_with_variant_inverted_index.groovy | 15 ++++++++-------
 1 file changed, 8 insertions(+), 7 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 69768659d59..79c63222045 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
@@ -210,12 +210,13 @@ 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"}'); """
+    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],
@@ -233,7 +234,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}; """


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

Reply via email to