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

morrysnow 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 3dcaa949e94 [fix](case)Fix multiple case tables with the same name 
causing case failure (#42203) (#43042)
3dcaa949e94 is described below

commit 3dcaa949e9483a390f9587e65dfdaec2c753130a
Author: zhangdong <[email protected]>
AuthorDate: Fri Nov 1 19:22:55 2024 +0800

    [fix](case)Fix multiple case tables with the same name causing case failure 
(#42203) (#43042)
    
    pick: from master #42203
---
 regression-test/suites/nereids_p0/union/test_union.groovy | 12 +++++++-----
 regression-test/suites/query_p0/union/test_union.groovy   | 12 +++++++-----
 2 files changed, 14 insertions(+), 10 deletions(-)

diff --git a/regression-test/suites/nereids_p0/union/test_union.groovy 
b/regression-test/suites/nereids_p0/union/test_union.groovy
index 5e9a9e71bf3..2d6f84235fe 100644
--- a/regression-test/suites/nereids_p0/union/test_union.groovy
+++ b/regression-test/suites/nereids_p0/union/test_union.groovy
@@ -21,6 +21,8 @@ suite("test_union") {
         SET enable_fallback_to_original_planner=false;
         set disable_nereids_rules='PRUNE_EMPTY_PARTITION';
     """
+    String suiteName = "nereids_union_test_union"
+    String viewName = "${suiteName}_view"
     def db = "nereids_test_query_db"
     sql "use ${db}"
 
@@ -177,14 +179,14 @@ suite("test_union") {
     // test_union_bug
     // PALO-3617
     qt_union36 """select * from (select 1 as a, 2 as b union select 3, 3) c 
where a = 1"""
-    sql """drop view if exists nullable"""
-    sql """CREATE VIEW `nullable` AS SELECT `a`.`k1` AS `n1`, `b`.`k2` AS `n2` 
+    sql """drop view if exists ${viewName}"""
+    sql """CREATE VIEW `${viewName}` AS SELECT `a`.`k1` AS `n1`, `b`.`k2` AS 
`n2` 
            FROM `${db}`.`baseall` a LEFT OUTER JOIN 
            `${db}`.`bigtable` b ON `a`.`k1` = `b`.`k1` + 10
            WHERE `b`.`k2` IS NULL"""
-    order_qt_union37 """select n1 from nullable union all select n2 from 
nullable"""
-    qt_union38 """(select n1 from nullable) union all (select n2 from nullable 
order by n1) order by n1"""
-    qt_union39 """(select n1 from nullable) union all (select n2 from 
nullable) order by n1"""
+    order_qt_union37 """select n1 from ${viewName} union all select n2 from 
${viewName}"""
+    qt_union38 """(select n1 from ${viewName}) union all (select n2 from 
${viewName} order by n1) order by n1"""
+    qt_union39 """(select n1 from ${viewName}) union all (select n2 from 
${viewName}) order by n1"""
 
 
     // test_union_different_column
diff --git a/regression-test/suites/query_p0/union/test_union.groovy 
b/regression-test/suites/query_p0/union/test_union.groovy
index f6b9f1e329b..87523ff81cc 100644
--- a/regression-test/suites/query_p0/union/test_union.groovy
+++ b/regression-test/suites/query_p0/union/test_union.groovy
@@ -16,6 +16,8 @@
 // under the License.
 
 suite("test_union") {
+    String suiteName = "query_union_test_union"
+    String viewName = "${suiteName}_view"
     def db = "test_query_db"
     sql "use ${db}"
 
@@ -172,14 +174,14 @@ suite("test_union") {
     // test_union_bug
     // PALO-3617
     qt_union36 """select * from (select 1 as a, 2 as b union select 3, 3) c 
where a = 1"""
-    sql """drop view if exists nullable"""
-    sql """CREATE VIEW `nullable` AS SELECT `a`.`k1` AS `n1`, `b`.`k2` AS `n2` 
+    sql """drop view if exists ${viewName}"""
+    sql """CREATE VIEW `${viewName}` AS SELECT `a`.`k1` AS `n1`, `b`.`k2` AS 
`n2` 
            FROM `${db}`.`baseall` a LEFT OUTER JOIN 
            `${db}`.`bigtable` b ON `a`.`k1` = `b`.`k1` + 10
            WHERE `b`.`k2` IS NULL"""
-    order_qt_union37 """select n1 from nullable union all select n2 from 
nullable"""
-    qt_union38 """(select n1 from nullable) union all (select n2 from nullable 
order by n1) order by n1"""
-    qt_union39 """(select n1 from nullable) union all (select n2 from 
nullable) order by n1"""
+    order_qt_union37 """select n1 from ${viewName} union all select n2 from 
${viewName}"""
+    qt_union38 """(select n1 from ${viewName}) union all (select n2 from 
${viewName} order by n1) order by n1"""
+    qt_union39 """(select n1 from ${viewName}) union all (select n2 from 
${viewName}) order by n1"""
 
 
     // test_union_different_column


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

Reply via email to