yiguolei commented on code in PR #25901:
URL: https://github.com/apache/doris/pull/25901#discussion_r1371552537
##########
regression-test/suites/correctness/test_pushdown_common_expr.groovy:
##########
@@ -65,6 +65,38 @@ suite("test_pushdown_common_expr") {
SELECT * FROM t_pushdown_common_expr WHERE c1 < 300 OR UPPER(c2)="F"
OR c3 LIKE "%f%";
"""
+ // One conjunct. No push down.
+ order_qt_5 """
+ SELECT * FROM t_pushdown_common_expr WHERE random() > 1 OR
uuid_numeric() = 'A' OR c1 = 256
+ """
+
+ // Two conjuncts.
+ // random() > 1 is executed by scan node, c1 > 0 is pushed down and
executed by segment iterator
+ order_qt_6 """
+ SELECT * FROM t_pushdown_common_expr WHERE random() > 1 AND c1 > 0
Review Comment:
寄一个select * from table where random() > 1 的测试case吧
##########
regression-test/suites/correctness/test_pushdown_common_expr.groovy:
##########
@@ -65,6 +65,38 @@ suite("test_pushdown_common_expr") {
SELECT * FROM t_pushdown_common_expr WHERE c1 < 300 OR UPPER(c2)="F"
OR c3 LIKE "%f%";
"""
+ // One conjunct. No push down.
+ order_qt_5 """
+ SELECT * FROM t_pushdown_common_expr WHERE random() > 1 OR
uuid_numeric() = 'A' OR c1 = 256
+ """
+
+ // Two conjuncts.
+ // random() > 1 is executed by scan node, c1 > 0 is pushed down and
executed by segment iterator
+ order_qt_6 """
+ SELECT * FROM t_pushdown_common_expr WHERE random() > 1 AND c1 > 0
Review Comment:
寄一个select * from table where random() > 1 的测试case吧
--
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]
