This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.1 by this push:
new ac3cbf1cf11 [branch-4.1][fix](regression) Fix tpch unique left anti
join db reference (#65338)
ac3cbf1cf11 is described below
commit ac3cbf1cf113b43a27ebeadc7472671ab182fe5d
Author: shuke <[email protected]>
AuthorDate: Fri Jul 10 09:39:20 2026 +0800
[branch-4.1][fix](regression) Fix tpch unique left anti join db reference
(#65338)
## Summary
Fix
`tpch_unique_sql_zstd_bucket1_p1/sql/test_left_anti_join_batch_size.sql`
to use the current suite database.
The case is in the `tpch_unique_sql_zstd_bucket1_p1` suite, but the
query hard-coded
`regression_test_tpch_unique_sql_zstd_bucket1_p0.lineitem`. In
branch-4.1 P1 runs, the P0 suite database is not guaranteed to exist, so
the test fails before exercising the left anti join query.
This patch replaces the stale fully qualified P0 table references with
unqualified `lineitem`, matching the rest of the suite and the
regression framework's suite DB routing.
## Testing
- [x] `git diff --check`
- [x] Verified the SQL diff only changes the two stale table references
- [x] `rg -n "regression_test_tpch_unique_sql_zstd_bucket1_p0|lineitem
l[13]"
regression-test/suites/tpch_unique_sql_zstd_bucket1_p1/sql/test_left_anti_join_batch_size.sql`
- [ ] Runtime regression validation: pending TeamCity buildall
---
.../sql/test_left_anti_join_batch_size.sql | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git
a/regression-test/suites/tpch_unique_sql_zstd_bucket1_p1/sql/test_left_anti_join_batch_size.sql
b/regression-test/suites/tpch_unique_sql_zstd_bucket1_p1/sql/test_left_anti_join_batch_size.sql
index 6a8dc6edf5c..af67ce10af0 100644
---
a/regression-test/suites/tpch_unique_sql_zstd_bucket1_p1/sql/test_left_anti_join_batch_size.sql
+++
b/regression-test/suites/tpch_unique_sql_zstd_bucket1_p1/sql/test_left_anti_join_batch_size.sql
@@ -1,16 +1,16 @@
-- tables: supplier,lineitem,orders,nation
-SELECT /*+SEV_VAR(batch_size=3)*/
+SELECT /*+SET_VAR(batch_size=3)*/
l1.l_orderkey okey,
l1.l_suppkey skey
FROM
- regression_test_tpch_unique_sql_zstd_bucket1_p0.lineitem l1
+ lineitem l1
WHERE
l1.l_receiptdate > l1.l_commitdate
AND l1.L_ORDERKEY < 10000
AND NOT exists(
SELECT *
FROM
- regression_test_tpch_unique_sql_zstd_bucket1_p0.lineitem l3
+ lineitem l3
WHERE
l3.l_orderkey = l1.l_orderkey
AND l3.l_suppkey <> l1.l_suppkey
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
