mrhhsg opened a new pull request, #70168:
URL: https://github.com/apache/doris/pull/70168
### What problem does this PR solve?
Issue Number: None
Related PR: #47303, #51497
Problem Summary: The TPC-DS SF1 UNIQUE and UNIQUE CK spill q24 suites
retained a birth-country equality predicate after the ordinary q24 queries
switched to inequality. Their expected nonempty rows also came from an older
query without the current-address join. With the current join and SF1 data,
those stale expectations cause false regression failures. Align the four spill
queries with the ordinary q24 SQL and regenerate their expected outputs.
### Release note
None
### Check List (For Author)
- Test
- [x] Regression test: regenerated four q24 spill outputs and reran all
four suites without generation; verified four ordinary q24 suites and two q01
spill controls. All 14 executions passed with no skipped suites.
- [x] ASAN BE/FE build and FE Checkstyle passed;
`./build-support/check-format.sh` and `git diff --check origin/master...HEAD`
passed.
- Behavior changed:
- [x] No product behavior change; only regression SQL and expected
outputs are corrected.
- Does this need documentation?
- [x] No.
--
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]
