924060929 commented on code in PR #54405:
URL: https://github.com/apache/doris/pull/54405#discussion_r2272785494
##########
regression-test/suites/query_p0/schema_table/test_view_dependency.groovy:
##########
@@ -97,5 +97,40 @@ suite("test_view_dependency") {
sql "create view stu_view_5 as select * from (select sid from mv_b) a join
grade using(sid);"
qt_sql "select * from information_schema.view_dependency where view_schema
= 'test_view_dependency_db' order by view_catalog,view_schema,view_name"
+
+ order_qt_filter_1 "select * from information_schema.view_dependency where
view_schema = 'test_view_dependency_db' and VIEW_NAME = 'mv_c'"
+ order_qt_filter_2 "select * from information_schema.view_dependency where
view_schema = 'test_view_dependency_db' and VIEW_NAME like 'mv_%'"
+ order_qt_filter_3 "select * from information_schema.view_dependency where
view_schema = 'test_view_dependency_db' and VIEW_NAME in('mv_c','mv_a')"
+ order_qt_filter_4 "select * from information_schema.view_dependency where
view_schema = 'test_view_dependency_db' and VIEW_TYPE = 'MATERIALIZED_VIEW'"
+ order_qt_filter_5 "select * from information_schema.view_dependency where
view_schema = 'test_view_dependency_db' and VIEW_TYPE = 'MATERIALIZED_VIEW' and
VIEW_NAME not in('mv_c','mv_a')"
+ order_qt_filter_6 "select * from information_schema.view_dependency where
view_schema = 'test_view_dependency_db' and VIEW_TYPE = 'MATERIALIZED_VIEW' or
VIEW_NAME = 'stu_view_1'"
+
+ // support eq
+ def explain = sql """explain select * from
information_schema.view_dependency where view_schema =
'test_view_dependency_db'"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support in
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema in ('test_view_dependency_db','test_view_dependency_db1')"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support not in
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema not in
('test_view_dependency_db','test_view_dependency_db1')"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support or
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema = 'test_view_dependency_db' or VIEW_NAME='stu_view_5'"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support >
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema > 'test_view_dependency_db'"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support >=
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema >= 'test_view_dependency_db'"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support <
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema < 'test_view_dependency_db'"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // support <=
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema <= 'test_view_dependency_db'"""
+ assertTrue(explain.toString().contains("FRONTEND PREDICATES"))
+ // not support like
+ explain = sql """explain select * from information_schema.view_dependency
where view_schema like '%test_view_dependency_db%'"""
+ assertFalse(explain.toString().contains("FRONTEND PREDICATES"))
}
Review Comment:
can these tests push down?
1. `where catalog.db.table.column='xxx'`
2. `where (db='xxx' or db='yyy') and (table='zzz' or table='aaa')`
3. `where (db='xxx' and table='yyy') or (db='zzz' and table='aaa')`
4. `where (push_expr1 and can_not_push_expr) or push_expr2`
--
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]
