yujun777 opened a new pull request, #70652:
URL: https://github.com/apache/doris/pull/70652

   ### Background
   
   The count rollup regression checks that aggregating an empty 
materialized-view input returns zero through sum0. The test refreshes an 
asynchronous materialized view and collects statistics before checking that the 
optimizer selects it.
   
   ### What problem does this PR solve?
   
   Issue Number: None
   Related PR: None
   PR Type: Test
   
   Problem Summary:
   
   The count_rollup_empty_input regression intermittently fails in cloud mode 
because the optimizer does not select the rewritten materialized-view plan. 
Refresh completion does not guarantee that row counts have been reported to the 
FE. Wait for the base table and materialized view row counts before collecting 
statistics, while keeping all plan and result assertions.
   
   ### Details
   
   - **Failure:** The plan check expects rollup_empty_mv to be chosen, but the 
failing plan reports a successful rewrite that was not chosen.
   - **Cause:** Statistics collection and plan selection can race with 
asynchronous row count reporting. The failed plan has unknown MV column 
statistics and equal candidate costs; the precise failing runtime sequence has 
not been confirmed from service logs.
   - **Stability evidence:** The same commit passed a subsequent cloud CI run. 
Reuse waitRowCountReady, already used by statistics regressions, to wait for 3 
base-table rows and 2 materialized-view rows before ANALYZE. Cloud execution of 
this change remains to be verified by CI.
   
   ### Testing
   
   - Local Groovy syntax compilation and git diff --check passed.
   - The regression framework built successfully and all 50 framework unit 
tests passed.
   - The repository runner loaded count_rollup_empty_input successfully with 
-dryRun.
   - An initial runner invocation attempted execution because the dry-run flag 
was supplied incorrectly; it stopped with connection refused because no local 
FE was running. No live cloud regression has been run for this change.
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Behavior changed: No
   - Does this need documentation: No
   - Pre-submission status: Partially verified: live cloud regression execution 
is pending CI.
   
   ### AI Disclosure
   
   - Tool: Codex
   - Generated: The regression change and this description.
   - Human review: The author approved committing the proposed change; no 
additional human review is claimed.
   


-- 
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]

Reply via email to