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 <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
