You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2024/02/04 14:22:07 UTC
(doris) 06/08: [test](mtmv)fix table name duplicate (#30808)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 88ff9c06cf69f3782ccbaed53d25e45098fc9cca
Author: zfr95 <87...@users.noreply.github.com>
AuthorDate: Sun Feb 4 21:22:15 2024 +0800
[test](mtmv)fix table name duplicate (#30808)
---
.../nereids_rules_p0/mv/dimension/dimension_2_4.groovy | 16 ++++++++--------
.../nereids_rules_p0/mv/dimension/dimension_2_5.groovy | 14 +++++++-------
.../nereids_rules_p0/mv/dimension/dimension_2_6.groovy | 8 ++++----
3 files changed, 19 insertions(+), 19 deletions(-)
diff --git a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
index 09b414588d7..60a3aed84ac 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_4.groovy
@@ -81,10 +81,10 @@ suite("partition_mv_rewrite_dimension_2_4") {
);"""
sql """
- drop table if exists partsupp
+ drop table if exists partsupp_2_4
"""
- sql """CREATE TABLE `partsupp` (
+ sql """CREATE TABLE `partsupp_2_4` (
`ps_partkey` INT NULL,
`ps_suppkey` INT NULL,
`ps_availqty` INT NULL,
@@ -124,7 +124,7 @@ suite("partition_mv_rewrite_dimension_2_4") {
"""
sql"""
- insert into partsupp values
+ insert into partsupp_2_4 values
(1, 1, 1, 99.5, 'yy'),
(null, 2, 2, 109.2, 'mm'),
(3, null, 1, 99.5, 'yy');
@@ -132,7 +132,7 @@ suite("partition_mv_rewrite_dimension_2_4") {
sql """analyze table orders_2_4 with sync;"""
sql """analyze table lineitem_2_4 with sync;"""
- sql """analyze table partsupp with sync;"""
+ sql """analyze table partsupp_2_4 with sync;"""
def create_mv_lineitem = { mv_name, mv_sql ->
sql """DROP MATERIALIZED VIEW IF EXISTS ${mv_name};"""
@@ -304,7 +304,7 @@ suite("partition_mv_rewrite_dimension_2_4") {
from orders_2_4
left join lineitem_2_4
on lineitem_2_4.l_orderkey = orders_2_4.o_orderkey
- left join partsupp on partsupp.ps_partkey = lineitem_2_4.l_orderkey"""
+ left join partsupp_2_4 on partsupp_2_4.ps_partkey = lineitem_2_4.l_orderkey"""
explain {
sql("${sql_stmt_4}")
contains "${mv_name_4}(${mv_name_4})"
@@ -329,7 +329,7 @@ suite("partition_mv_rewrite_dimension_2_4") {
def sql_stmt_5 = """select o_orderdate, o_shippriority, o_comment
from orders_2_4
left join lineitem_2_4 on lineitem_2_4.l_orderkey = orders_2_4.o_orderkey
- left join partsupp on partsupp.ps_partkey = lineitem_2_4.l_orderkey
+ left join partsupp_2_4 on partsupp_2_4.ps_partkey = lineitem_2_4.l_orderkey
group by
o_orderdate,
o_shippriority,
@@ -370,7 +370,7 @@ suite("partition_mv_rewrite_dimension_2_4") {
bitmap_union(to_bitmap(case when o_shippriority > 2 and o_orderkey IN (2) then o_custkey else null end)) as cnt_2
from orders_2_4
left join lineitem_2_4 on lineitem_2_4.l_orderkey = orders_2_4.o_orderkey
- left join partsupp on partsupp.ps_partkey = lineitem_2_4.l_orderkey
+ left join partsupp_2_4 on partsupp_2_4.ps_partkey = lineitem_2_4.l_orderkey
group by
o_orderdate,
o_shippriority,
@@ -470,7 +470,7 @@ suite("partition_mv_rewrite_dimension_2_4") {
// bitmap_union(to_bitmap(case when o_shippriority > 2 and o_orderkey IN (2) then o_custkey else null end)) as cnt_2
// from orders_2_4
// left join lineitem_2_4 on lineitem_2_4.l_orderkey = orders_2_4.o_orderkey
-// left join partsupp on partsupp.ps_partkey = lineitem_2_4.l_orderkey
+// left join partsupp_2_4 on partsupp_2_4.ps_partkey = lineitem_2_4.l_orderkey
// where l_shipdate >= "2023-10-15"
// group by
// o_orderdate,
diff --git a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
index c42e27e1da0..762408ba057 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_5.groovy
@@ -81,10 +81,10 @@ suite("partition_mv_rewrite_dimension_2_5") {
);"""
sql """
- drop table if exists partsupp
+ drop table if exists partsupp_2_5
"""
- sql """CREATE TABLE `partsupp` (
+ sql """CREATE TABLE `partsupp_2_5` (
`ps_partkey` INT NULL,
`ps_suppkey` INT NULL,
`ps_availqty` INT NULL,
@@ -124,7 +124,7 @@ suite("partition_mv_rewrite_dimension_2_5") {
"""
sql"""
- insert into partsupp values
+ insert into partsupp_2_5 values
(1, 1, 1, 99.5, 'yy'),
(null, 2, 2, 109.2, 'mm'),
(3, null, 1, 99.5, 'yy');
@@ -132,7 +132,7 @@ suite("partition_mv_rewrite_dimension_2_5") {
sql """analyze table orders_2_5 with sync;"""
sql """analyze table lineitem_2_5 with sync;"""
- sql """analyze table partsupp with sync;"""
+ sql """analyze table partsupp_2_5 with sync;"""
def create_mv_lineitem = { mv_name, mv_sql ->
sql """DROP MATERIALIZED VIEW IF EXISTS ${mv_name};"""
@@ -297,7 +297,7 @@ suite("partition_mv_rewrite_dimension_2_5") {
def sql_stmt_5 = """select o_orderdate, o_shippriority, o_comment
from orders_2_5
left join lineitem_2_5 on lineitem_2_5.l_orderkey = orders_2_5.o_orderkey
- left join partsupp on partsupp.ps_partkey = lineitem_2_5.l_orderkey
+ left join partsupp_2_5 on partsupp_2_5.ps_partkey = lineitem_2_5.l_orderkey
group by
o_orderdate,
o_shippriority,
@@ -311,7 +311,7 @@ suite("partition_mv_rewrite_dimension_2_5") {
def sql_stmt_5_2 = """select o_orderdate, o_shippriority, o_comment
from orders_2_5
left join lineitem_2_5 on lineitem_2_5.l_orderkey = orders_2_5.o_orderkey
- left join partsupp on partsupp.ps_partkey = orders_2_5.o_orderkey
+ left join partsupp_2_5 on partsupp_2_5.ps_partkey = orders_2_5.o_orderkey
group by
o_orderdate,
o_shippriority,
@@ -410,7 +410,7 @@ suite("partition_mv_rewrite_dimension_2_5") {
// bitmap_union(to_bitmap(case when o_shippriority > 2 and o_orderkey IN (2) then o_custkey else null end)) as cnt_2
// from orders_2_5
// left join lineitem_2_5 on lineitem_2_5.l_orderkey = orders_2_5.o_orderkey
-// left join partsupp on partsupp.ps_partkey = lineitem_2_5.l_orderkey
+// left join partsupp_2_5 on partsupp_2_5.ps_partkey = lineitem_2_5.l_orderkey
// where l_shipdate >= "2023-10-15"
// group by
// o_orderdate,
diff --git a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
index f3bce205cda..59977c70503 100644
--- a/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/dimension/dimension_2_6.groovy
@@ -81,10 +81,10 @@ suite("partition_mv_rewrite_dimension_2_6") {
);"""
sql """
- drop table if exists partsupp
+ drop table if exists partsupp_2_6
"""
- sql """CREATE TABLE `partsupp` (
+ sql """CREATE TABLE `partsupp_2_6` (
`ps_partkey` INT NULL,
`ps_suppkey` INT NULL,
`ps_availqty` INT NULL,
@@ -124,7 +124,7 @@ suite("partition_mv_rewrite_dimension_2_6") {
"""
sql"""
- insert into partsupp values
+ insert into partsupp_2_6 values
(1, 1, 1, 99.5, 'yy'),
(null, 2, 2, 109.2, 'mm'),
(3, null, 1, 99.5, 'yy');
@@ -132,7 +132,7 @@ suite("partition_mv_rewrite_dimension_2_6") {
sql """analyze table orders_2_6 with sync;"""
sql """analyze table lineitem_2_6 with sync;"""
- sql """analyze table partsupp with sync;"""
+ sql """analyze table partsupp_2_6 with sync;"""
def create_mv_lineitem = { mv_name, mv_sql ->
sql """DROP MATERIALIZED VIEW IF EXISTS ${mv_name};"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org