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

starocean999 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 041a5a5f6fe [regression](show)fix show load warnings (#56020)
041a5a5f6fe is described below

commit 041a5a5f6fe253ba53cd0351f64a45e1cb31425b
Author: lsy3993 <[email protected]>
AuthorDate: Mon Sep 15 14:14:45 2025 +0800

    [regression](show)fix show load warnings (#56020)
---
 .../show/test_nereids_show_load_warnings.groovy    | 30 ++++++++++------------
 1 file changed, 13 insertions(+), 17 deletions(-)

diff --git 
a/regression-test/suites/nereids_p0/show/test_nereids_show_load_warnings.groovy 
b/regression-test/suites/nereids_p0/show/test_nereids_show_load_warnings.groovy
index 9d74c1f59a5..ff9aa3cf917 100644
--- 
a/regression-test/suites/nereids_p0/show/test_nereids_show_load_warnings.groovy
+++ 
b/regression-test/suites/nereids_p0/show/test_nereids_show_load_warnings.groovy
@@ -56,28 +56,24 @@ suite("test_nereids_show_load_warnings") {
             """
         waitForBrokerLoadDone("${load_label}")
 
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db limit 1")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where label = '${load_label}'")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where label = '${load_label}' limit 1")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = 123")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = 123 limit 1")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = 123 and label = 
'${load_label}'")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = 123 and label = 
'${load_label}' limit 1")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = 123")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = 123 limit 1")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = 123 and label = 
'${load_label}'")
-        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = 123 and label = 
'${load_label}' limit 1")
-
-        def res1 = sql """SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db limit 1"""
-        assertEquals("${load_label}", res1.get(0).get(1))
-
         def res2 = sql """SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where label = '${load_label}'"""
-        assertEquals("${load_label}", res2.get(0).get(1))
+        assertEquals(new String("${load_label}"), new 
String(res2.get(0).get(1).toString()))
 
         def jobid = res2.get(0).get(0)
         def res3 = sql """SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = ${jobid}"""
         assertEquals(1, res3.size())
+
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where label = '${load_label}'")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where label = '${load_label}' limit 1")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = ${jobid}")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = ${jobid} limit 1")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = ${jobid} and label = 
'${load_label}'")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where LOAD_JOB_ID = ${jobid} and label = 
'${load_label}' limit 1")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = ${jobid}")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = ${jobid} limit 1")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = ${jobid} and label = 
'${load_label}'")
+        checkNereidsExecute("SHOW LOAD WARNINGS FROM 
test_nereids_show_load_warnnings_db where JobId = ${jobid} and label = 
'${load_label}' limit 1")
+
     }
     sql "DROP TABLE IF EXISTS test_nereids_show_load_warningns_tbl "
     sql "drop database if exists  test_nereids_show_load_warnnings_db"


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

Reply via email to