test: show stats in explain of two representative queries
Which issue does this PR close?
Tests for https://github.com/apache/arrow-datafusion/issues/8155
Rationale for this change
I have found that statistics were lost being propagated upward in the plan. These are tests that include representative operators for us to verify whether the statistics are computed and propagated up correctly
What changes are included in this PR?
Add 2 explains
Are these changes tested?
They are tests only
Are there any user-facing changes?
No
marking as draft to show this PR isn't waiting for review
@alamb : It seems there are improvements in statistics recently. Do you think we still need this kind of tests?
I think the tests in this PR add value as they function as an end to end test of statistics calculation and propagation -- perhaps we can move them to a different .slt file (statistics.slt perhaps)?
Thank you for your contribution. Unfortunately, this pull request is stale because it has been open 60 days with no activity. Please remove the stale label or comment or this will be closed in 7 days.