seawinde commented on code in PR #31538:
URL: https://github.com/apache/doris/pull/31538#discussion_r1507195188
##########
regression-test/suites/nereids_rules_p0/mv/dimension_equal/filter_equal_or_notequal.groovy:
##########
@@ -158,132 +158,132 @@ suite("filter_equal_or_notequal_case") {
where l_shipdate = '2023-10-17'
"""
- create_mv_lineitem(mv_name, mtmv_sql)
- def job_name = getJobName(db, mv_name)
- waitingMTMVTaskFinished(job_name)
-
- // mv equal and sql equal
- def query_sql = """
- select l_shipdate, o_orderdate, l_partkey, l_suppkey
- from lineitem_1
- left join orders_1
- on lineitem_1.l_orderkey = orders_1.o_orderkey
- where l_shipdate = '2023-10-17'
- """
- def res_tmp = sql """explain ${query_sql}"""
- logger.info("res_temp:" + res_tmp)
- explain {
- sql("${query_sql}")
- contains "${mv_name}(${mv_name})"
- }
- compare_res(query_sql + " order by 1,2,3,4")
-
- // mv equal and sql not equal
- query_sql = """
- select l_shipdate, o_orderdate, l_partkey, l_suppkey
- from lineitem_1
- left join orders_1
- on lineitem_1.l_orderkey = orders_1.o_orderkey
- where l_shipdate != '2023-10-17'
- """
- explain {
- sql("${query_sql}")
- notContains "${mv_name}(${mv_name})"
- }
-
- // mv equal and sql equal and number is difference
- query_sql = """
- select l_shipdate, o_orderdate, l_partkey, l_suppkey
- from lineitem_1
- left join orders_1
- on lineitem_1.l_orderkey = orders_1.o_orderkey
- where l_shipdate = '2023-10-19'
- """
- explain {
- sql("${query_sql}")
- notContains "${mv_name}(${mv_name})"
- }
-
- mtmv_sql = """
- select l_shipdate, o_orderdate, l_partkey, l_suppkey, o_orderkey
- from lineitem_1
- left join orders_1
- on lineitem_1.l_orderkey = orders_1.o_orderkey
- where l_shipdate != '2023-10-17'
- """
-
- create_mv_lineitem(mv_name, mtmv_sql)
- job_name = getJobName(db, mv_name)
- waitingMTMVTaskFinished(job_name)
-
- // mv not equal and sql equal
- query_sql = """
- select l_shipdate, o_orderdate, l_partkey, l_suppkey
- from lineitem_1
- left join orders_1
- on lineitem_1.l_orderkey = orders_1.o_orderkey
- where l_shipdate = '2023-10-17'
- """
- explain {
- sql("${query_sql}")
- notContains "${mv_name}(${mv_name})"
- }
-
- // mv not equal and sql not equal
- query_sql = """
- select l_shipdate, o_orderdate, l_partkey, l_suppkey
- from lineitem_1
- left join orders_1
- on lineitem_1.l_orderkey = orders_1.o_orderkey
- where l_shipdate != '2023-10-17'
- """
- explain {
- sql("${query_sql}")
- contains "${mv_name}(${mv_name})"
- }
- compare_res(query_sql + " order by 1,2,3,4")
-
-
+// create_mv_lineitem(mv_name, mtmv_sql)
Review Comment:
should add, will fixed
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
