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]
