This is an automated email from the ASF dual-hosted git repository.
eldenmoon pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new b38286c3981 [Fix](regresson) fix vcompound constant column regression
case (#28560)
b38286c3981 is described below
commit b38286c3981bb898c2c84d9c3caead7e4a26c049
Author: airborne12 <[email protected]>
AuthorDate: Mon Dec 18 18:18:58 2023 +0800
[Fix](regresson) fix vcompound constant column regression case (#28560)
---
regression-test/suites/query_p0/test_constant_fold.groovy | 12 +++++++-----
1 file changed, 7 insertions(+), 5 deletions(-)
diff --git a/regression-test/suites/query_p0/test_constant_fold.groovy
b/regression-test/suites/query_p0/test_constant_fold.groovy
index bb8026ccd37..2e3f371cf76 100644
--- a/regression-test/suites/query_p0/test_constant_fold.groovy
+++ b/regression-test/suites/query_p0/test_constant_fold.groovy
@@ -34,19 +34,21 @@ suite("test_constant_fold", "query") {
sql """ INSERT INTO ${testTable} VALUES (false) """
sql """ INSERT INTO ${testTable} VALUES (true) """
+ sql """ set experimental_enable_nereids_planner = true """
+ sql """ set enable_fallback_to_original_planner = false """
sql """ set enable_fold_constant_by_be=true """
qt_select """ SELECT SUM(count) FROM
- (SELECT CAST((NOT ((1378719999)||(CASE ${testTable}.c0 WHEN
${testTable}.c0 THEN -388844163 WHEN ${testTable}.c0 THEN 1455674610 ELSE
671348352 END ))) IS NOT NULL AND
- (NOT ((1378719999)||(CASE ${testTable}.c0 WHEN
${testTable}.c0 THEN -388844163 WHEN ${testTable}.c0 THEN 1455674610 ELSE
671348352 END ))) AS INT) as count
+ (SELECT CAST((NOT ((true)||(CASE ${testTable}.c0 WHEN
${testTable}.c0 THEN false WHEN ${testTable}.c0 THEN true ELSE true END ))) IS
NOT NULL AND
+ (NOT ((true)||(CASE ${testTable}.c0 WHEN ${testTable}.c0 THEN
false WHEN ${testTable}.c0 THEN true ELSE true END ))) AS INT) as count
FROM ${testTable}) as res;
"""
- sql """ set enable_fold_constant_by_be=false """
+ sql """ set enable_fold_constant_by_be=true """
qt_select """ SELECT SUM(count) FROM
- (SELECT CAST((NOT ((1378719999)||(CASE ${testTable}.c0 WHEN
${testTable}.c0 THEN -388844163 WHEN ${testTable}.c0 THEN 1455674610 ELSE
671348352 END ))) IS NOT NULL AND
- (NOT ((1378719999)||(CASE ${testTable}.c0 WHEN
${testTable}.c0 THEN -388844163 WHEN ${testTable}.c0 THEN 1455674610 ELSE
671348352 END ))) AS INT) as count
+ (SELECT CAST((NOT ((true)||(CASE ${testTable}.c0 WHEN
${testTable}.c0 THEN false WHEN ${testTable}.c0 THEN true ELSE true END ))) IS
NOT NULL AND
+ (NOT ((true)||(CASE ${testTable}.c0 WHEN ${testTable}.c0 THEN
false WHEN ${testTable}.c0 THEN true ELSE true END ))) AS INT) as count
FROM ${testTable}) as res;
"""
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
