apurtell commented on PR #2510: URL: https://github.com/apache/phoenix/pull/2510#issuecomment-4666850197
## Test Results ### Unit tests (connectionless) | Test | Run | Failures | Errors | Skipped | Result | | --- | ---: | ---: | ---: | ---: | :---: | | `org.apache.phoenix.query.explain.ExplainPlanTest` | 63 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.compile.QueryCompilerTest` | 215 | 0 | 0 | 2 | PASS | `ExplainPlanTest` includes the new `testUnionAllOfHashJoins` case covering the deeply nested union-of-hash-joins explain output (union root → branch scan → hash-join sub-plan), plus the updated `testHashJoinInner`, `testHashJoinSemiInSubquery`, `testSortMergeJoin`, and `testUnionAll`. ### Integration tests | Test | Run | Failures | Errors | Skipped | Result | | --- | ---: | ---: | ---: | ---: | :---: | | `org.apache.phoenix.end2end.join.HashJoinNoIndexIT` | 33 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.HashJoinGlobalIndexIT` | 33 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.HashJoinLocalIndexIT` | 34 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.HashJoinMoreIT` | 10 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.index.IndexUsageIT` | 39 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.index.GlobalIndexOptimizationIT` | 7 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.QueryWithTableSampleIT` | 12 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.UnionAllIT` | 19 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.CostBasedDecisionIT` | 20 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.SortMergeJoinNoIndexIT` | 35 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.SortMergeJoinGlobalIndexIT` | 35 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.SortMergeJoinLocalIndexIT` | 35 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.SortMergeJoinMoreIT` | 10 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.join.SubqueryUsingSortMergeJoinIT` | 21 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.tpcds.TPCDSLikeSingleChannelIT` | 28 | 0 | 0 | 0 | PASS | | `org.apache.phoenix.end2end.tpcds.TPCDSLikeCrossChannelIT` | 12 | 0 | 0 | 0 | PASS | The two `TPCDSLike*IT` classes are new TPC-DS derived ITs that exercise joins and unions. Each query runs over a deterministic fixture and is parameterized across `NO_INDEX` and `GLOBAL_INDEX` schemas. Every case asserts the full ordered result plus the EXPLAIN operator markers (`HASH BUILD`, `UNION ALL OVER N QUERIES`, `SORT-MERGE-JOIN (INNER/FULL)`) in both parameters, and additionally verifies covering-index usage (`SS_I`, `INV_I`, `CS_I`) in the `GLOBAL_INDEX` parameter where the optimizer rewrites the fact-table scan onto a global index. ### Totals - Unit tests: 278 run, 0 failures, 0 errors (2 skipped). - Integration tests: 383 run, 0 failures, 0 errors, 0 skipped. - **Overall: 661 run, 0 failures, 0 errors.** -- 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]
